Small or Large, same principle....but yes, I tried that & it cites error saying: "You have entered too many arguments for this function"
=LARGE($C$45,$E$45,$G$45,$I$45,$K$45,$M$45,$O$45,$Q$45,ROWS($C$50:C50))
what am I doing wrong?
Thanks, it is working . . . I now want to return the "Column header name," based in this LARGE value, how can I use the INDEX & MATCH function to do this in the next column next to the value?
Row\Col | C | D | E | F | G | H | I | J | K |
44 | fred | alyosha | carol | dave | nate | ||||
45 | 5 | 3 | 5 | 2 | 3 | ||||
46 | |||||||||
47 | |||||||||
48 | |||||||||
49 | |||||||||
50 | 5 | fred | |||||||
51 | 5 | carol | |||||||
52 | 3 | alyosha | |||||||
53 | 3 | nate | |||||||
54 | 2 | dave | |||||||
55 |