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

[Guest]

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

 

[VBA Noob]

=IF(COUNTIF($E$3:$E$500,F3)>1,TRUE,FALSE)

More help on attached link

http://www.cpearson.com/excel/duplicat.htm

VBA Noo