Biff wrote:

Hi!

Enter this in I2:

=INDEX($B$1:$H$1,MATCH(SMALL($B2:$H2,COUNTIF($B2:$ H2,0)+COLUMNS($A:A)),$B2:$H2,0))

Copy across to J2. Then select both I2 and J2 and copy down to row 10.

Biff

This seems to do the trick!! Nice work around. Thank you Biff.

All the other suggestions also worked as well. Thanks all.

Bullman