Spreadsheet: 874724d1721252700-get-max-value-based-onanother-cell-maxium
Sheet: Sheet1

 |  |  | MAX | MAX | MAX | MAX | MAX
29462 | [NAME] | A | 25330.44 | 25709.95 | 93454 | 0 | 93759.6
29463 | SAM | B
29464 | JOANN | D
29465 | SAM | E
29466 | PETE | F
29493 | MARY | G
29462 | [NAME] | A | 209.84 | 25500.11 | 63698.61 | 0 | 89408.56
29463 | SAM | B | 258.95 | 776.61 | 25748.29 | 0 | 26265.95
29464 | JOANN | D | 1409.77 | 3394.89 | 1085343.93 | 0 | 1090148.59
29465 | SAM | E | 81.63 | 4044.1 | 35507.45 | 0 | 39633.18
29466 | PETE | F | 29316.95 | 0 | 1860094.04 | 0 | 1889410.99
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 73.91 | 25709.95 | 62202.02 | 0 | 87838.06
29463 | SAM | B | 280.8 | 776.61 | 25497.48 | 0 | 25993.29
29464 | JOANN | D | 275.07 | 4804.66 | 1078018.87 | 0 | 1082548.46
29465 | SAM | E | 32.6 | 4125.73 | 33901.34 | 0 | 37994.47
29466 | PETE | F | 559.14 | 29316 | 2002795.31 | 0 | 2032670.45
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 25636.04 | 64649.97 | 0 | 90286.01
29463 | SAM | B | 0 | 495.81 | 25994.19 | 0 | 26490
29464 | JOANN | D | 0 | 4529.59 | 1103815.68 | 0 | 1108345.27
29465 | SAM | E | 0 | 4093.13 | 35206.61 | 0 | 39299.74
29466 | PETE | F | 0.14 | 29875 | 2050490.21 | 0 | 2080365.35
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 25636.04 | 65073.55 | 0 | 90709.59
29463 | SAM | B | 3.01 | 495.81 | 26145.77 | 0 | 26644.59
29464 | JOANN | D | 4.4 | 4529.59 | 1104253.53 | 0 | 1108787.52
29465 | SAM | E | 0 | 4093.13 | 35202.07 | 0 | 39295.2
29466 | PETE | F | 0.14 | 29875 | 2049741.62 | 0 | 2079616.76
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 25636.04 | 65453.15 | 0 | 91089.19
29463 | SAM | B | 0 | 498.82 | 26296.81 | 0 | 26795.63
29464 | JOANN | D | 164.14 | 4533.99 | 1107226.48 | 0 | 1111924.61
29465 | SAM | E | 0 | 4093.13 | 35343.32 | 0 | 39436.45
29466 | PETE | F | 1532.03 | 29875 | 2055451.15 | 0 | 2086858.18
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 25636.04 | 65545.64 | 0 | 91181.68
29463 | SAM | B | 0 | 498.82 | 26434.75 | 0 | 26933.57
29464 | JOANN | D | 0 | 4698.13 | 1106087.44 | 0 | 1110785.57
29465 | SAM | E | 0 | 4093.13 | 35472.17 | 0 | 39565.3
29466 | PETE | F | 0.03 | 31407 | 2054481.36 | 0 | 2085888.39
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 25330.44 | 25636.04 | 91046.71 | 0 | 91352.31
29463 | SAM | B | 0 | 498.82 | 26481.81 | 0 | 26980.63
29464 | JOANN | D | 0 | 4698.13 | 1098508.82 | 0 | 1103206.95
29465 | SAM | E | 3952.96 | 4093.13 | 39498.52 | 0 | 39638.69
29466 | PETE | F | 0.03 | 31407 | 2043171.79 | 0 | 2074578.82
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 9876.44 | 10182.04 | 91219.82 | 0 | 91525.42
29463 | SAM | B | 0 | 498.82 | 26481 | 0 | 26979.82
29464 | JOANN | D | 0 | 4698.13 | 1101875.12 | 0 | 1106573.25
29465 | SAM | E | 3952.96 | 4093.13 | 39271.45 | 0 | 39411.62
29466 | PETE | F | 0.03 | 31407 | 2046654.75 | 0 | 2078061.78
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 305.6 | 91130.56 | 0 | 91436.16
29463 | SAM | B | 0 | 498.82 | 26385.37 | 0 | 26884.19
29464 | JOANN | D | 0 | 4698.13 | 1104262.12 | 0 | 1108960.25
29465 | SAM | E | 0 | 140.17 | 39350.37 | 0 | 39490.54
29466 | PETE | F | 150802.62 | 31407 | 2051083.87 | 0 | 2233293.49
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 305.6 | 91597.6 | 0 | 91903.2
29463 | SAM | B | 0 | 498.82 | 26518.31 | 0 | 27017.13
29464 | JOANN | D | 0 | 4698.13 | 1108988.42 | 0 | 1113686.55
29465 | SAM | E | 0 | 140.17 | 39780.37 | 0 | 39920.54
29466 | PETE | F | 529999.38 | 182209 | 2590795.75 | 0 | 2243005.37
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 305.6 | 91810.21 | 0 | 92115.81
29463 | SAM | B | 0 | 498.82 | 26569.67 | 0 | 27068.49
29464 | JOANN | D | 0 | 4698.13 | 1110809.61 | 0 | 1115507.74
29465 | SAM | E | 0 | 140.17 | 40127.12 | 0 | 40267.29
29466 | PETE | F | 529999.38 | 182209 | 2600488.58 | 0 | 2252698.2
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 305.6 | 92412.16 | 0 | 92717.76
29463 | SAM | B | 0 | 498.82 | 26672.33 | 0 | 27171.15
29464 | JOANN | D | 0 | 4698.13 | 1116368.54 | 0 | 1121066.67
29465 | SAM | E | 0 | 140.17 | 40322.43 | 0 | 40462.6
29466 | PETE | F | 149999.38 | 182209 | 2231103.19 | 0 | 2263312.81
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0
29462 | [NAME] | A | 0 | 305.6 | 93454 | 0 | 93759.6
29463 | SAM | B | 0 | 498.82 | 26862.97 | 0 | 27361.79
29464 | JOANN | D | 0 | 4698.13 | 1140186.87 | 0 | 1144885
29465 | SAM | E | 0 | 140.17 | 40854.05 | 0 | 40994.22
29466 | PETE | F | 0.62 | 32209 | 2265319.42 | 0 | 2297529.04
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | H | 0.62 | 37851.72 | 3566677.31 | 0 | 3604529.65
29462 | [NAME] | A | 0 | 305.6 | 92552.12 | 0 | 92857.72
29463 | SAM | B | 0 | 498.82 | 26649.52 | 0 | 27148.34
29464 | JOANN | D | 0 | 4698.13 | 1133453.24 | 0 | 1138151.37
29465 | SAM | E | 0 | 140.17 | 40144.19 | 0 | 40284.36
29466 | PETE | F | 0.62 | 32209 | 2246912.29 | 0 | 2279121.91
29493 | MARY | G | 0 | 0 | 0 | 0 | 0
30380 | HARRY | H | 0 | 0 | 0 | 0 | 0