How to show the 3 lowest values of a range, when some of those values might be the same?

[helpneeded2]

I am using a formula with SMALL to find the 3 lowest values in a row, and to return the corresponding row header. The problem I have run into is if 1 or more values are tied in that position.

Based on the code used below, if "5" is the lowest value and is in 2 columns of the row of data, then the result for Column 1 (1st lowest) and Column 2 (2nd lowest) will both show the same header, as it is only referencing the first instance of "5".

Is there a better/different way to do this with Excel?

Column 1:

=INDEX($BU$1:$CV$1,MATCH(SMALL(BU2493:CV2493,1),BU2493:CV2493,0))

Column 2:

=INDEX($BU$1:$CV$1,MATCH(SMALL(BU2493:CV2493,2),BU2493:CV2493,0))

Column 3:

=INDEX($BU$1:$CV$1,MATCH(SMALL(BU2493:CV2493,3),BU2493:CV2493,0))

 

[Fluff]

How about

=INDEX(SORTBY($BU$1:$CV$1,BU2493:CV2493),1,{1,2,3})

put this in one cell only & it will across.

 

[helpneeded2]

How about

=INDEX(SORTBY($BU$1:$CV$1,BU2493:CV2493),1,{1,2,3})

put this in one cell only & it will across.

Thank you.

 

[Fluff]

Glad to help & thanks for the feedback.