Thread
:
How do I return the cell address of the largest of a set of values
View Single Post
#
2
papou
Posts: n/a
Hello
Try this array formula (validate with Ctrl + Shift + Enter):
=ADDRESS(MIN(IF(B3:Z51=LARGE(B3:Z51,1),ROW(B3:Z51) )),MIN(IF(B3:Z51=LARGE(B3:Z51,1),COLUMN(B3:Z51))))
HTH
Cordially
Pascal
"Mr. Snrub" <Mr.
a écrit dans le message de
news:
...
I have a table of integers ranging from cells B3 to Z51, and I want to find
the cell address of the largest value.
=LARGE(B3:Z51, 1) will give me the largest value, but how do I find the
cell
address where that largest value is located?
Reply With Quote