On Monday, July 8, 2013 4:14:14 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Mon, 8 Jul 2013 03:37:56 -0700 (PDT) schrieb :



Joe Martin

Silvia Jacob

Nathan Lewis

Joe Samantha

Silvia Jerry

Nathan Britney

Joe Sheila

Silvia Roger

Nathan Randolph

Joe Cherry

Silvia Jerrard

Nathan Monica



So if Joe is in F1 the list should be:



Martin

Samantha

Sheila

Cherry



try in G1:

=INDEX(B:B,SMALL(IF(A$1:A$100=$F$1,ROW($1:$100)),R OW(A1)))

and enter the array formula with CTRl+Shift+Enter and copy down till you

get an error

Regards

Claus B.

Thanks Claus, I will pass this on with credit to you.
Works pretty nice.

Regards,
Howard