Similar to the mathematical "arg max" (see https://en.wikipedia.org/wiki/Arg_max), ROWMAX(<region>) should return the number of the (first) row, where MAX(<region>) is reached.
1: 6 4
2: 2 8
, ARGMAX(A1:B2) should be 2.
Given a table with columns "year" and "income", calculate the year with highest income.
This is an enhancement request, looks resonable for me.
Set to NEW.
Additionally, there should be COLMAX,COLMIN for the number of the maximal/minimal column.
I just see that my description is inconsistent: It should be ROWMAX, not ARGMAX.
Actually, maybe ARGMAX is even better than ROWMAX/COLMAX: It could return the cell reference of the maximal/minimal value. In my use case, the year with maximal income would then be "=OFFSET(ARGMAX(<income column>), 0, -1)".
Hmm - I just found out that the whole functionality is partially covered by HLOOKUP/VLOOKUP. In my use case, the "income" column would need to be left of the "year" column, then the year with maximal income is "=VLOOKUP(MAX(<income column>), <table region>, 2, FALSE)".