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
display which cell it refers to?
Thanks
Diane
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
Assume your data in columnA
="A"&MATCH(MAX(A:A),A:A,0)
="A"&MATCH(MAX(A:A),A:A,0)
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---
=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
Thanks so much - it worked beautifully
Teethless mama said:Assume your data in columnA
="A"&MATCH(MAX(A:A),A:A,0)
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---