get the location of a maximum in a row

  • Thread starter Thread starter ANDY
  • Start date Start date
A

ANDY

HI!
Have troubles to get the location (refernce e.g. B3) from
a maximum in a row (e.g. the maximum in Row B is in Cell
B3) Is it possible without macros? How?
Thanks
 
I´m not sure I follow you but try this:

=ADDRESS(MATCH(MAX(B:B),B:B),2,4,1)

Change number 2 for the column number 2 is for B
Change Number 4 for Absolut/relative output 4 is for
relative on Row and Column
Change Number 1 for Z100 or R1C1 notation

Cheers
Juan
 
In my first post i mixed up rows and colums. I hav a row
with numbers. I want to find the Address of the maximum.
Considering your advice I think you meant the same as I
did. I tried to your code but it didn't came out the way
I thougt. It presented always the address of the last
value in the row.
Do you know why? and how to fix it?

Thanks very much for your support
ANDY
 
ANDY

Try this:

=ADDRESS(2,MATCH(MAX(2:2),2:2),4,1)

Look at the formula this way:

=Address(A,B,C,D)
A= this is the row which you already know so just input it.
B= This is the column, which you need to find, use the
formula to find the column number of the maximum value in
row 2,
C & D stay the same...

Cheers
Juan
 
Thank you...
I added a 0 to the match type of the match function and
altered the desired rows and colums at the address
function and now it workd:

=ADDRESS(MATCH(MAX(A:A),A:A,0),2,4,1)
Thank you
 
Back
Top