Max function
 

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

Thanks

Diane

Max function
 

Assume your data in columnA

="A"&MATCH(MAX(A:A),A:A,0)


"DianeG" wrote:

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

Thanks

Diane

Max function
 

I found this function on this same DG a long time ago:
=ADDRESS(MAX((A1:B5=LARGE(A1:B5,C1))*ROW(A1:B5)),M AX((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---

--
RyGuy


"Teethless mama" wrote:

Assume your data in columnA

="A"&MATCH(MAX(A:A),A:A,0)


"DianeG" wrote:

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

Thanks

Diane

Max function
 

Thanks so much - it worked beautifully

"Teethless mama" wrote:

Assume your data in columnA

="A"&MATCH(MAX(A:A),A:A,0)


"DianeG" wrote:

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

Thanks

Diane

Max function
 

Thank you very much - this worked as well

"ryguy7272" wrote:

I found this function on this same DG a long time ago:
=ADDRESS(MAX((A1:B5=LARGE(A1:B5,C1))*ROW(A1:B5)),M AX((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---

--
RyGuy


"Teethless mama" wrote:

Assume your data in columnA

="A"&MATCH(MAX(A:A),A:A,0)


"DianeG" wrote:

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

Thanks

Diane