Max function

D

DianeG

Is there any way when obtaining a result for the Max function that you can
display which cell it refers to?

Thanks

Diane
 
R

ryguy7272

I found this function on this same DG a long time ago:
=ADDRESS(MAX((A1:B5=LARGE(A1:B5,C1))*ROW(A1:B5)),MAX((A1:B5=LARGE(A1:B5,C1))*COLUMN(A1:B5)),4)
Note: The function should go in Cell D1. The data resides in range A1:B5.
In C1, you choose the column that you want to look in for the max value
(i.e., column 1, column 2, etc.)

Regards,
Ryan---
 
D

DianeG

Thank you very much - this worked as well

ryguy7272 said:
I found this function on this same DG a long time ago:
=ADDRESS(MAX((A1:B5=LARGE(A1:B5,C1))*ROW(A1:B5)),MAX((A1:B5=LARGE(A1:B5,C1))*COLUMN(A1:B5)),4)
Note: The function should go in Cell D1. The data resides in range A1:B5.
In C1, you choose the column that you want to look in for the max value
(i.e., column 1, column 2, etc.)

Regards,
Ryan---
Click to expand...
 

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

Compressing multiple functions across an array into one cell 6
Want To Shrink Formula 1
Max Function 3
Look for Max and second Max 0
Making MAX and MIN range variable 1
Excel - Wich Function should I use? 1
Find max and return corresponding value 1
MAX Function Issue 2

Top