| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
