Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Largest and Return Column Name
I am comparing 3 columns and trying to find the maximum value of the columns.
But instead of just displaying the maximum value I would like it to show which column the value is from. OBS_ID CLASS1 CLASS2 CLASS3 A 2 5 10 B 12 10 4 C 5 1 15 D 2 6 12 E 1 23 9 So in this case, when the formula is run it will return "CLASS3" for Row A and "CLASS1" for Row B and so on.. Thanks for you help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Largest and Return Column Name
Assuming that your Column Titles are in Row1 and that Data begins Row2 =INDEX(A1:D1,0,MATCH(MAX(A2:D2),A2:D2,0)) -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=523634 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Largest and Return Column Name
Thanks, that worked perfectly
"kraljb" wrote: Assuming that your Column Titles are in Row1 and that Data begins Row2 =INDEX(A1:D1,0,MATCH(MAX(A2:D2),A2:D2,0)) -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=523634 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find formula for largest value in multiple cells | New Users to Excel | |||
return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
look up number in column | Excel Worksheet Functions | |||
How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) |