How do I return the cell location

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

excuse my typo

 

[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.

 

[Guest]

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.

Thank you very much my friend!!!