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. :)

try this if row is apples and row 2 is 9

=INDEX(1:1,MATCH(MAX(2:2),2:2))

--
Don Guillett
SalesAid Software

"Treesy" wrote in message
...
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. :)

Assuming your header in column A1:C1

=INDEX (A1:C1,MATCH(MAX(A2:C2),A2:C2,0))


"Treesy" wrote:

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. :)

Thanks!! That works perfectly!

"Teethless mama" wrote:

Assuming your header in column A1:C1

=INDEX (A1:C1,MATCH(MAX(A2:C2),A2:C2,0))


"Treesy" wrote:

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. :)