Excel - get address of cell

  • Thread starter Thread starter Irina
  • Start date Start date
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
 
Irina

=CELL("address",OFFSET(A1,MATCH(MAX(A1:A3),A1:A3,FALSE)-1,0))
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Sum n+1 5
Calculating a cell reference 2
Copy multiple values into a single cell 4
BUG in excel iteration system? Very simple illustrative example: can you replicate? 3
How to get address of cell calling UDF? 2
MACRO HELP 2
Macro that analyses data from 3 columns and puts result in 4th 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Back
Top