Hi all,
I have a data sheet with 10 rows and 7 columns starting in A1. The question is to write a formula which gives the row number where the sum of that particular row is the highest (max).
But while working with helping columns I can easily solve this issue, I've been tasked to find one array formula to return this value, so one formula only.
Any idea on how to do this? I thought that this might do the trick:
{=MAX(SUBTOTAL(9,OFFSET(Data,ROW(Data)-ROW(A1),0,1)))}
but it gives me the actual sum of the row with the maximum sum: not the row itself.
Any help is appreciated, thanks!
Bookmarks