| 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 |
| 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) | |||
Threaded Mode
