Hi Bob,

Unfortunately LARGE does not work if there are identical values. In the
third row you get STAPLES three times...

I suggest to enter into G1:O1
=RANK($B1,$B1:$F1) =RANK($D1,$B1:$F1)+COUNTIF($B1,$D1) =RANK($F1,$B1:$F1)+COUNTIF($B1:$D1,$F1) =INDEX($A1:$F1,MATCH(1,$G1:$I1,)*2-1) =INDEX($A1:$F1,MATCH(1,$G1:$I1,)*2) =INDEX($A1:$F1,MATCH(2,$G1:$I1,)*2-1) =INDEX($A1:$F1,MATCH(2,$G1:$I1,)*2) =INDEX($A1:$F1,MATCH(3,$G1:$I1,)*2-1) =INDEX($A1:$F1,MATCH(3,$G1:$I1,)*2)

then copy down as far as required.

Regards,
Bernd