View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Treesy Treesy is offline
external usenet poster
 
Posts: 20
Default Help with comparing information...

I need help finding a formula that will look at a row of totals and find the
largest total and input the column header. Example:

Oranges Bananas Apples

4 3 9


Look at the row of totals and determine that the most sold were apples. In
a particular cell, put the word "apples". I'm assuming that the formula
could reference the cells that the words are in instead of the actual words?
Thank you for your help. :)