View Single Post
  #2   Report Post  
papou
 
Posts: n/a
Default

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?