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]

In this case (if 2nd value appeared twice) do you want to display both headers? Like ETF-C, ETF-D?

 

[centaur87]

yes for 2nd largest it should return the first which appears like in this case ETF-C and 3rd Largest it should return the second one as ETF-D

 

[KOKOSEK]

ETF-D is not 3rd is also 2nd...

 

[centaur87]

but i cant skip ETF-D hence i want it as 3rd, or let me how to resolve this.

 

[centaur87]

Output required sample :

1st Large	2nd Large	3rd Large	4th Large
ETF-B	ETF-C	ETF-D	ETF-A
	OR
1st Large	2nd Large	3rd Large	4th Large
ETF-B	ETF-D	ETF-C	ETF-A

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[KOKOSEK]

It is your case but to be honest in my opinion if should be:
1st ETF-B
2nd ETF-C, ETF-D
3rd ETF-A

as ETF-C and D has the same value.

 

[sandy666]

maybe something like this:

ETF-A	ETF-B	ETF-C	ETF-D		Max	Custom
30​	6​	30​	30​		30​	ETF-A, ETF-C, ETF-D
					6​	ETF-B

 

[centaur87]

@KOKOSEK, so what will be formula to get the result as per what you have explained

 

[centaur87]

please help me with the formula