How do I return the cell location
 

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.

How do I return the cell location
 

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

"aneuro" wrote:

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.

How do I return the cell location
 

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

excuse my typo


"aneuro" wrote:

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.

How do I return the cell location
 

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

Roger Govier


"aneuro" wrote in message
...
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.

How do I return the cell location
 

"Roger Govier" wrote:

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

Roger Govier


Thank you very much my friend!!!