Hi
Well I swear that I entered the formulae, and in edit mode, I hold down
the ctrt. shift, and enter keys, it hilights the columns and rows, but
it does not put the brackets{}, and then I get an error message
The formula is
=IF(COLUMNS($A:A)<=COUNTIF($A2:$F2,MIN($A2:$F2)),I NDEX($A1:$F1,SMALL(IF($A2**:$F2=MIN($A2:$F2),COLUM N($A1:$F1)-COLUMN($A:$A)+1),COLUMNS($A:A))),""),
the same you posted me, still give error, I have the impression that
the array formulae entering is not working, any help? I am using excel
2003
Jam