I used the formula =MAX(A1:A999)
the returned value is 1.7933
cell A998 contains value 1.7933
What formula can I use to let me know which cell the value was taken from?
Of course, I can go thought the 999 values manually until A998, but there would take a long time.
I'm looking for something like that
=max-cell-info(A1:A999)
return result will be A998
the returned value is 1.7933
cell A998 contains value 1.7933
What formula can I use to let me know which cell the value was taken from?
Of course, I can go thought the 999 values manually until A998, but there would take a long time.
I'm looking for something like that
=max-cell-info(A1:A999)
return result will be A998
Last edited: