Hi
I posted this message, I got the next answer, I copied the array
formulae and paste it , it gives error, I enter it by typing still give
error
Any help?
Jam
Hi
Anyone can solve this problem
I have 2 rows
a b c d e f
46 55 66 46 55 56
I used min fuction it gives me the first 46
I want to to hvae the 2 46 with the names a and d
If can not solve this since it has one criterion
Thanks for any help
Jam

Hi!
Assume this data is in the range A1:F2
a b c d e f
46 55 66 46 55 56
Enter this formulas as an array using the key combination of
CTRL,SHIFT,ENTER in cell A5 and copy across to F5:
=IF(COLUMNS($A:A)<=COUNTIF($A2:$F2,MIN($A2:$F2)),I NDEX($A1:$F1,SMALL(IF($A2*:$F2=MIN($A2:$F2),COLUMN ($A1:$F1)-COLUMN($A:$A)+1),COLUMNS($A:A))),"")

Enter this formula in A6 and copy across to F6:
=IF(A5="","",INDEX($A2:$F2,MATCH(A5,$A1:$F1,0)))
The results will be:
...........A..........B..........C..........D..... .....E..........F..........*.

5........a...........d............................ ..........................*.......

6.......46.........46............................. ..........................*.....



Biff