Is there a formula to obtain the row number not the position number of the maximum value in a range such as A11:A50? I can do it in VBA but was hoping I could do it with a formula. I have tried several things but continue to get errors. Row doesn't seem to work except with cell address only. I know this doesn't work: =ROW(CELL("address",INDEX(A11:A50,MATCH(MAX(A11:A50),A11:A50,0))))
Thanks in advance for any help I may get. Mr. Excel forum is the best.
Thanks in advance for any help I may get. Mr. Excel forum is the best.