Listing the Value Label for highest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 columns containing numbers in which I need the 6th column to report
back the Column Heading of the Cell in the columns 1-5 that has the highest
value.

So, if the headings were North, East, South, West, and Central (in A1-E1)
and Heading in F1 was Highest Value. AND, if the values for A2 t hrough E2
were 96,84, 14, 100,50, the value for F1 would be "West"....

thanks,
Craig
 
Back
Top