Spreadsheet: 866978d1713886726-offset-formula-for-dynamic-range-offset-workbook
Sheet: Sheet1

 |  |  |  |  |  |  | Current Formula |  |  |  |  | Desired Output
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 37
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 45
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Chastain | 43
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Eull | 61
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Kuehn | 29
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Larson | 55
 | First | Last | Age |  |  |  |  |  |  |  |  | [NAME] | Lindenfelser | 32
 | [NAME] | [NAME] | 37 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 54
 | [NAME] | [NAME] | 45 |  |  |  |  |  |  |  |  | [NAME] | Mahoney | 56
 | [NAME] | Chastain | 43 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 35
 | [NAME] | Eull | 61 |  |  |  |  |  |  |  |  | Leah | [NAME] | 30
 | [NAME] | Kuehn | 29 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 44
 | [NAME] | Larson | 55 |  |  |  |  |  |  |  |  | Damon | [NAME] | 57
 | [NAME] | Lindenfelser | 32 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 24
 | [NAME] | [NAME] | 54 |  |  |  |  |  |  |  |  | Dimtry | [NAME] | 53
 | [NAME] | Mahoney | 56 |  |  |  |  |  |  |  |  | Jon | Schoen | 56
 | [NAME] | [NAME] | 35 |  |  |  |  |  |  |  |  | Kristine | Schoen | 56
 | Leah | [NAME] | 30 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 28
 | [NAME] | [NAME] | 44 |  |  |  |  |  |  |  |  | [NAME] | Smith | 58
 | Damon | [NAME] | 57 |  |  |  |  |  |  |  |  | [NAME] | Smith | 29
 | [NAME] | [NAME] | 24 |  |  |  |  |  |  |  |  | [NAME] | Smith | 59
 | Dimtry | [NAME] | 53 |  |  |  |  |  |  |  |  | Tristan | Smith | 26
 | Jon | Schoen | 56 |  |  |  |  |  |  |  |  | Michelle | [NAME] | 49
 | Kristine | Schoen | 56 |  |  |  |  |  |  |  |  | Nicole | Sylvester | 42
 | [NAME] | [NAME] | 28 |  |  |  |  |  |  |  |  | [NAME] | Wassermann | 46
 | [NAME] | Smith | 58 |  |  |  |  |  |  |  |  | [NAME] | Whalen | 44
 | [NAME] | Smith | 29 |  |  |  |  |  |  |  |  | [NAME] | Wick | 38
 | [NAME] | Smith | 59 |  |  |  |  |  |  |  |  | Kayla | Wilmot | 33
 | Tristan | Smith | 26 |  |  |  |  |  |  |  |  | [NAME] | Woolhouse | 55
 | Michelle | [NAME] | 49
 | Nicole | Sylvester | 42
 | [NAME] | Wassermann | 46
 | [NAME] | Whalen | 44
 | [NAME] | Wick | 38
 | Kayla | Wilmot | 33
 | [NAME] | Woolhouse | 55
 | Total
 | First | Last | Age
 | [NAME] | [NAME] | 37
 | [NAME] | [NAME] | 45
 | [NAME] | Chastain | 43
 | [NAME] | Eull | 61
 | [NAME] | Kuehn | 29
 | [NAME] | Larson | 55
 | [NAME] | Lindenfelser | 32
 | [NAME] | [NAME] | 54
 | [NAME] | Mahoney | 56
 | [NAME] | [NAME] | 35
 | Leah | [NAME] | 30
 | [NAME] | [NAME] | 44
 | Damon | [NAME] | 57
 | [NAME] | [NAME] | 24
 | Dimtry | [NAME] | 53
 | Jon | Schoen | 56
 | Kristine | Schoen | 56
 | [NAME] | [NAME] | 28
 | [NAME] | Smith | 58
 | [NAME] | Smith | 29
 | [NAME] | Smith | 59
 | Tristan | Smith | 26
 | Michelle | [NAME] | 49
 | Nicole | Sylvester | 42
 | [NAME] | Wassermann | 46
 | [NAME] | Whalen | 44
 | [NAME] | Wick | 38
 | Kayla | Wilmot | 33
 | [NAME] | Woolhouse | 55
 | Total
 | First | Last | Age
 | [NAME] | [NAME] | 37
 | [NAME] | [NAME] | 45
 | [NAME] | Chastain | 43
 | [NAME] | Eull | 61
 | [NAME] | Kuehn | 29
 | [NAME] | Larson | 55
 | [NAME] | Lindenfelser | 32
 | [NAME] | [NAME] | 54
 | [NAME] | Mahoney | 56
 | [NAME] | [NAME] | 35
 | Leah | [NAME] | 30
 | [NAME] | [NAME] | 44
 | Damon | [NAME] | 57
 | [NAME] | [NAME] | 24
 | Dimtry | [NAME] | 53
 | Jon | Schoen | 56
 | Kristine | Schoen | 56
 | [NAME] | [NAME] | 28
 | [NAME] | Smith | 58
 | [NAME] | Smith | 29
 | [NAME] | Smith | 59
 | Tristan | Smith | 26
 | Michelle | [NAME] | 49
 | Nicole | Sylvester | 42
 | [NAME] | Wassermann | 46
 | [NAME] | Whalen | 44
 | [NAME] | Wick | 38
 | Kayla | Wilmot | 33
 | [NAME] | Woolhouse | 55
 | Total
 | First | Last | Age
 | [NAME] | [NAME] | 37
 | [NAME] | [NAME] | 45
 | [NAME] | Chastain | 43
 | [NAME] | Eull | 61
 | [NAME] | Kuehn | 29
 | [NAME] | Larson | 55
 | [NAME] | Lindenfelser | 32
 | [NAME] | [NAME] | 54
 | [NAME] | Mahoney | 56
 | [NAME] | [NAME] | 35
 | Leah | [NAME] | 30
 | [NAME] | [NAME] | 44
 | Damon | [NAME] | 57
 | [NAME] | [NAME] | 24
 | Dimtry | [NAME] | 53
 | Jon | Schoen | 56
 | Kristine | Schoen | 56
 | [NAME] | [NAME] | 28
 | [NAME] | Smith | 58
 | [NAME] | Smith | 29
 | [NAME] | Smith | 59
 | Tristan | Smith | 26
 | Michelle | [NAME] | 49
 | Nicole | Sylvester | 42
 | [NAME] | Wassermann | 46
 | [NAME] | Whalen | 44
 | [NAME] | Wick | 38
 | Kayla | Wilmot | 33
 | [NAME] | Woolhouse | 55
 | Total
 | First | Last | Age
 | [NAME] | [NAME] | 37
 | [NAME] | [NAME] | 45
 | [NAME] | Chastain | 43
 | [NAME] | Eull | 61
 | [NAME] | Kuehn | 29
 | [NAME] | Larson | 55
 | [NAME] | Lindenfelser | 32
 | [NAME] | [NAME] | 54
 | [NAME] | Mahoney | 56
 | [NAME] | [NAME] | 35
 | Leah | [NAME] | 30
 | [NAME] | [NAME] | 44
 | Damon | [NAME] | 57
 | [NAME] | [NAME] | 24
 | Dimtry | [NAME] | 53
 | Jon | Schoen | 56
 | Kristine | Schoen | 56
 | [NAME] | [NAME] | 28
 | [NAME] | Smith | 58
 | [NAME] | Smith | 29
 | [NAME] | Smith | 59
 | Tristan | Smith | 26
 | Michelle | [NAME] | 49
 | Nicole | Sylvester | 42
 | [NAME] | Wassermann | 46
 | [NAME] | Whalen | 44
 | [NAME] | Wick | 38
 | Kayla | Wilmot | 33
 | [NAME] | Woolhouse | 55
 | Total