how do I find 2nd highest MAX in a row

C

cruise director

I need the forumla to find the 2nd highest Max in a row. example:



High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME
0 0 0 0 0 0
 
C

cruise director

I keep getting formula error or it just shows me the MAX. Is there any easier
solution?
 
Top