Spreadsheet: 44544d1243326839-from-a-value-select-a-range-then-find-the-specify-the-highest-figure-book1-1-
Sheet: Sheet1

Reading | Amount | Begin | End | This gives location (Reading number) where range needs to begin selection. | [NAME] needed to find where end point is reached in the [NAME], starting from the begin point. | With the Begin point and the End point to select a range, the highest figure then needs to be found within.
 |  |  |  |  | Figures are manually inputted for explanation
1 | 98.27 | 99.15 | 98.11999999999999 | 8 | 12 | 101.57 | 99.69 | 101.04 | 101.57 | 100.22 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1
2 | 99.06 | 99.59 | 98.91 | 8 | 13 | 101.57 | 99.69 | 101.04 | 101.57 | 100.22 | 99.1 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09
3 | 98.96 | 99.29 | 98.80999999999999 | 8 | 13 | 101.57 | 99.69 | 101.04 | 101.57 | 100.22 | 99.1 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09
4 | 98.95 | 99.31 | 98.8 | 8 | 13 | 101.57 | 99.69 | 101.04 | 101.57 | 100.22 | 99.1 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09
5 | 98.8322 | 99.25 | 98.6822 | 8 | 13 | 101.57 | 99.69 | 101.04 | 101.57 | 100.22 | 99.1 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09
6 | 97.79 | 98.04 | 97.64 | 1 | 7 | 99.06 | 98.27 | 99.06 | 98.96 | 98.95 | 98.8322 | 97.79 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44 | 96.44
7 | 96.44 | 97.12 | 96.28999999999999 | 1 | 15 | 101.57 | 98.27 | 99.06 | 98.96 | 98.95 | 98.8322 | 97.79 | 96.44 | 99.69 | 101.04 | 101.57 | 100.22 | 99.1 | 98.09 | 99.01 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24
8 | 99.69 | 100.31 | 99.53999999999999 | 9 | 14 | 101.57 | 101.04 | 101.57 | 100.22 | 99.1 | 98.09 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01
9 | 101.04 | 101.32 | 100.89 | 10 | N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
10 | 101.57 | 101.52 | 100.7 | 10 | N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
11 | 100.22 |  |  |  |  |  | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22 | 100.22
12 | 99.1 |  |  |  |  |  | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1 | 99.1
13 | 98.09 |  |  |  |  |  | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09 | 98.09
14 | 99.01 |  |  |  |  |  | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01 | 99.01
15 | 96.24 |  |  |  |  |  | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24 | 96.24