Combining lists to find duplicates

[Guest]

I have two lists of names in Excel. Each list has about 2000 names, and there are roughly 250 names that appear on both lists. I need to find out if I can combine the lists in some way and isolate the 250 names that appear on both lists.

If anyone has any advice, please send me an email.

Thanks,
Austin

 

[Ken Wright]

List 1 in Col A, list 2 in Col D.

In B1 put =IF(COUNTIF(D,A1)>0,"MATCH","") and copy down as far as needed.

In E1 put =IF(COUNTIF(A:A,D1)>0,"MATCH","") and copy down as far as needed.

On each column, use Autofilter to get just the cells with MATCH in, then select
the corresponding range of values do edit / Go To / Visible cells only, copy the
data and paste into another column.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have two lists of names in Excel. Each list has about 2000 names, and there

are roughly 250 names that appear on both lists. I need to find out if I can
combine the lists in some way and isolate the 250 names that appear on both
lists.