Find 2nd and 3rd highest numbers in a row and return column header

[centaur87]

[TABLE="width: 670"]
<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">[TR]
[TD]ETF-A[/TD]
[TD]ETF-B[/TD]
[TD]ETF-C[/TD]
[TD]ETF-D[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]27[/TD]
[TD]11[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]
[FONT=&quot]I cannot seem to write the formula that would return the column header of the second largest value.

In above Case, first Largest value is 27, it will return ETF-B
But 2nd largest has duplicate values, hence what formula shall i write to return [/FONT][FONT=&quot]the column header of the second largest value.

Best Regards.
[/FONT]

 

[KOKOSEK]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]ETF-A[/td][td]ETF-B[/td][td]ETF-C[/td][td]ETF-D[/td][td]

27​

[/td][td]ETF-B[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

10​

[/td][td]

27​

[/td][td]

11​

[/td][td]

11​

[/td][td]

11​

[/td][td]ETF-C,ETF-D[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td][/td][td][/td][td][/td][td][/td][td]

10​

[/td][td]ETF-A[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td]

0​

[/td][td][/td][/tr]
[/table]
Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

=MAX($A$2:$D$2)​

[/td][td]=TEXTJOIN(",",1,IF($A$2:$D$2=E1,$A$1:$D$1,""))[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

=MAX(IF($A$2:$D$2<E1,$A$2:$D$2))​

[/td][td]=TEXTJOIN(",",1,IF($A$2:$D$2=E2,$A$1:$D$1,""))[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

=MAX(IF($A$2:$D$2<E2,$A$2:$D$2))​

[/td][td]=TEXTJOIN(",",1,IF($A$2:$D$2=E3,$A$1:$D$1,""))[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

=MAX(IF($A$2:$D$2<E3,$A$2:$D$2))​

[/td][td]=TEXTJOIN(",",1,IF($A$2:$D$2=E4,$A$1:$D$1,""))[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]


Formula in F1 is array so you have to accept it with Ctrl+Shift+Enter not just Enter.