How do I return the cell address of the largest of a set of values
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?
|