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

centaur87

New Member
ETF-AETF-BETF-CETF-D
10271111

<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

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

centaur87

New Member
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
 

centaur87

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

centaur87

New Member
Output required sample :

1st Large2nd Large3rd Large4th Large
ETF-BETF-CETF-D ETF-A


OR
1st Large2nd Large3rd Large4th Large
ETF-BETF-DETF-C ETF-A



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

KOKOSEK

Board Regular
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

Well-known Member
maybe something like this:

ETF-AETF-BETF-CETF-DMaxCustom
30​
6​
30​
30​
30​
ETF-A, ETF-C, ETF-D
6​
ETF-B
 

Some videos you may like

This Week's Hot Topics

Top