View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom321
 
Posts: n/a
Default 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