Friday, May 30, 2014

yogi_Find The Title Of Column(s) (in row 1) For The Maximum Value(s) In Row 2


                                         Google Spreadsheet   Post  #1654
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-30-2014
post by HellWatcher: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/waWuUEs9GiY)
Help With Formula
Hello. I am trying to firgure out how to find the max value between 3 columns and return the title of that column.

Example:
a  b  c
1  2  3
In that example I would want a cell to show me c not the number 3.
---
I can do it with a long series of IF statements but if anyone has a suggestion on something shorter and easier to mange, that would be awesome.
=IF ( AND ( K6 > L6 , K6 > M6 ) , "A" , IF ( AND ( L6 > K6 , L6 > M6 ) , "B" , IF ( AND ( M6 > K6 , M6 > L6 ) , "C" , IF ( AND ( K6 = L6 , K6 =M6 ) , "A & B & C" , IF ( K6 = M6 , "A & C" , IF ( L6 = M6 , "B & C" , IF ( K6 = L6 , "A & B" , "ERROR" )))))))
---
I also need it to skip any zero values.
-----------------------------------------------------------------------------------------------------------------------------------------------