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

[centaur87]

ETF-A	ETF-B	ETF-C	ETF-D
10	27	11	11

<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>

[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]

	A​	B​	C​	D​	E​	F​
1​	ETF-A	ETF-B	ETF-C	ETF-D	27​	ETF-B
2​	10​	27​	11​	11​	11​	ETF-C,ETF-D
3​					10​	ETF-A
4​					0​

Excel 2016 (Windows) 32 bit

	E​	F​
1​	=MAX($A$2:$D$2)​	=TEXTJOIN(",",1,IF($A$2:$D$2=E1,$A$1:$D$1,""))
2​	=MAX(IF($A$2:$D$2<E1,$A$2:$D$2))​	=TEXTJOIN(",",1,IF($A$2:$D$2=E2,$A$1:$D$1,""))
3​	=MAX(IF($A$2:$D$2<E2,$A$2:$D$2))​	=TEXTJOIN(",",1,IF($A$2:$D$2=E3,$A$1:$D$1,""))
4​	=MAX(IF($A$2:$D$2<E3,$A$2:$D$2))​	=TEXTJOIN(",",1,IF($A$2:$D$2=E4,$A$1:$D$1,""))

Sheet: Sheet1

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