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/