Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display row of the maximum in a list
Hey all,
I have a question regarding extractingt the row of the maximum number in a list and referencing the cell next to it.. For instance, A B 1 Data1 12 2 Data2 13 3 Data3 18 4 Data4 17 I want to find the maximum in column B (18) and display the A column (Data3). It seems simple but I can't seem to do it for some reason. Thanks for all the hope in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display row of the maximum in a list
Hi
Assuming your data is between A1 and b4 use =offset(B1,match(max(B:B),B:B,0)-1,-1,1,1) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Sungibungi" escreveu: Hey all, I have a question regarding extractingt the row of the maximum number in a list and referencing the cell next to it.. For instance, A B 1 Data1 12 2 Data2 13 3 Data3 18 4 Data4 17 I want to find the maximum in column B (18) and display the A column (Data3). It seems simple but I can't seem to do it for some reason. Thanks for all the hope in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display row of the maximum in a list
One way:
=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0)) Note that if there are multiple instances of the max value the formula will "find" the 1st instance from the top. -- Biff Microsoft Excel MVP "Sungibungi" wrote in message ... Hey all, I have a question regarding extractingt the row of the maximum number in a list and referencing the cell next to it.. For instance, A B 1 Data1 12 2 Data2 13 3 Data3 18 4 Data4 17 I want to find the maximum in column B (18) and display the A column (Data3). It seems simple but I can't seem to do it for some reason. Thanks for all the hope in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display maximum value of matching values in a different column | Excel Discussion (Misc queries) | |||
How do I find the maximum time value from a list | Excel Worksheet Functions | |||
Maximum selections in a mutil list box | Excel Discussion (Misc queries) | |||
maximum value in a list less than specified value | Excel Discussion (Misc queries) | |||
Hyperlink display text maximum in Excel 2003 | Excel Discussion (Misc queries) |