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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2