Hi
first post here, hopefully someone can help.

I have a spreadsheet with a set of values attached to names, in rows.

I want to choose the 3 lowest values in each row and return the column headings and have set up these formulae in cells BP-BR.
=INDEX($AJ$1:$BN$1,,MATCH(SMALL($AJ101:$BN101,1),$ AJ101:$BN101,0))
=INDEX($AJ$1:$BN$1,,MATCH(SMALL($AJ101:$BN101,2),$ AJ101:$BN101,0))
=INDEX($AJ$1:$BN$1,,MATCH(SMALL($AJ101:$BN101,3),$ AJ101:$BN101,0))
which works fine if all values are different.
However if 2 or 3 columns have the same value all 3 cells return the same column heading.

How can I get the formula to return the heading from the 2nd and 3rd occurrence of minimum values?

TIA