Screen Shot 2012-06-13 at 12.15.54 PM.png
As in the example screenshot, I am trying to display the column header of the greatest value in a row. So if the greatest value in Car 1's row is 92 and the header to the column that 92 is in is "Blue", the column E should display "Blue".
I thought to use MAX() then HLOOKUP(), but am unfamiliar with how to implement.
Bookmarks