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