How do you compare names in two lists? One is a subset.

M

MAG

I want to Identify names from a larger list that are in the smallerlist. What
is the best way to do this? I tried using =ISNA(Match(F3,$E$3:$E$500,TRUE)),
where column F contains all of the names in array $E$3:$E$500 and about 3000
more. I had hoped to identify those in the array with a True or False and
then use a sort to select out the True entries.

Thanks
 
Top