I like your idea to list each relative position of the max value.
I'd prefer to avoid the array formulas, though, and go with something like this:
Using your sample structure:
D2: =MAX(A2:A51)
D3: =COUNTIF(A2:A51,D2)
D4: Result
D5: =IF(ROWS($5:5)<=$D$3,MATCH($D$2,$A$2:$A$51,0),"")
D6: =IF(ROWS($5:6)<=$D$3,MATCH($D$2,INDEX($A$2:$A$51,D5+1):$A$51,0)+D5,"")
Copy D6 down as far as needed.
Note: Those formulas return the RELATIVE POSTITION of the
max value(s) in the referenced range. If the actual row number is required:
D5: =IF(ROWS($5:5)<=$D$3,MATCH($D$2,$A$2:$A$51,0)+ROW($A$1),"")
EDITED TO CORRECT THE BELOW FORMULA
D6: =IF(ROWS($5:6)<=$D$3,MATCH($D$2,INDEX($A:$A,D5+1):$A$51,0)+D5,"")
Bookmarks