Hello all, this is driving me absolutely mad, MATCH is returning the wrong value, for only this set of data.
<tbody>
</tbody>Where you see "10" at the bottom is the formula =MATCH(MAX(F5:F14),F5:F14) -------------[F5:F14 is the range including 0.59, 0.37 and 1.31]
The formulas in the F5:F14 are {=SUM(IF(($C$2:$C$4=E6),$B$2:$B$4,0))} ---------- E6 in this case is referencing "25" and that formula is dragged down through "70"
Clearly the max value is in position 7 not 10.
Thanks for any feedback!
0.59 | 30 | |||
0.37 | 35 | |||
1.31 | 55 | |||
25 | 0 | |||
30 | 0.59 | |||
35 | 0.37 | |||
40 | 0 | |||
45 | 0 | |||
50 | 0 | |||
55 | 1.31 | |||
60 | 0 | |||
65 | 0 | |||
70 | 0 | |||
10 |
<tbody>
</tbody>
The formulas in the F5:F14 are {=SUM(IF(($C$2:$C$4=E6),$B$2:$B$4,0))} ---------- E6 in this case is referencing "25" and that formula is dragged down through "70"
Clearly the max value is in position 7 not 10.
Thanks for any feedback!