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

--
Message posted from http://www.ExcelForum.com

Irina

=CELL("address",OFFSET(A1,MATCH(MAX(A1:A3),A1:A3,F ALSE)-1,0))

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Irina " wrote in message
...
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 that
content is Max, for instance a2?

Thank in advance, Irina.


---
Message posted from http://www.ExcelForum.com/

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

"Irina " wrote in message
...
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 that
content is Max, for instance a2?

Thank in advance, Irina.


---
Message posted from http://www.ExcelForum.com/