Excel - get address of cell

I

Irina

Hi people,

Condition : cell(AXX) = Max(A1:AXX-1)
a1 = 100
a2 = 300
a3 = 50
.....
Problem : Could I by any chance get the address of the cell tha
content is Max, for instance a2?

Thank in advance, Irina
 
B

Bernie Deitrick

Irina,

The address of the Maximum value in A is

=ADDRESS(MATCH(MAX(A:A),A:A,FALSE),COLUMN(A:A))

unless the formula is in column A, then you need to use

=ADDRESS(MATCH(MAX(A1:A100),A1:A100,FALSE),COLUMN(A:A))

HTH,
Bernie
MS Excel MVP
 
Top