View Single Post
  #1   Report Post  
Mr. Snrub
 
Posts: n/a
Default 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?