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

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

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

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

More help on attached link

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564894