How do I return the cell location

A

aneuro

How do I return the cell location (in addition to the value contained in the
cell) of the maximum value in an Excel array?

I'm trying to locate the row number for the maximum value in a column of
numbers.
 
M

Mike H

Try:-

=ADDRESS(MIN(IF((A1:B4)=MAX(A1:B4),ROW(A1:B4),"")),COLUMN(A1:B4))

alter the array address as required. It's an array formula so enter with
ctrl+shift+enter


Mike
 
R

Roger Govier

Hi

To just return the row number in say column A, then
MATCH(MAX(A:A),A:A,0)

To get the cell Address
=ADDRESS(MATCH(MAX(A:A),A:A,0),1)
where the 1 refers to column A. Adjust accordingly if you change column
letter.
 
A

aneuro

Roger Govier said:
Hi

To just return the row number in say column A, then
MATCH(MAX(A:A),A:A,0)

To get the cell Address
=ADDRESS(MATCH(MAX(A:A),A:A,0),1)
where the 1 refers to column A. Adjust accordingly if you change column
letter.
Click to expand...
Thank you very much my friend!!!
 
Top