View Single Post
  #3   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

Mr. Snrub wrote:
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?


Be aware of the fact that there can be multiple instances of the largest
value. See:

http://tinyurl.com/dph4d