Hi,

Try this. Suppose the data is in range A9:B11. Enter Blue in cell A13. In
cell B13, array enter (Ctrl+Shift+Enter) the following

=IF(ISERROR(INDEX($A$9:$B$11,SMALL(IF($B$9:$B$11=$ A$13,ROW($B$9:$B$11)),ROW(1:1))-ROW(B$8),1)),"",INDEX($A$9:$B$11,SMALL(IF($B$9:$B$ 11=$A$13,ROW($B$9:$B$11)),ROW(1:1))-ROW(B$8),1))

Now you can copy this formula down

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"rafael" wrote in message
...
imagine i have two rows: name and color:
mary blue
ken brown
will blue

what i want is having, in another row, just the names that have blue eyes,
like
mary
will

thank you