Duplicate entries

D

dancingbear72

Hi. I've searched the forum and I know there have been a few posts o
this subject but nothing quite what I need.

Here's my pronlem.

I have 2 lists of names. One with around 12,000 on it and one wit
around 3,000. What I need to do is check the 3,000 against the 12,00
and create a new list of the names in the 3,000 that ARE NOT in th
12,000.

How can I do this? I don't have much experience with excel so i
someone could explain simply or tell me a macro and how to implement i
that would be much appreciated.

Many thanks in advance
Ro
 
D

DNF Karran

=VLOOKUP(B1,$A:$A,1,FALSE) should do.

It will return N/A if it can't find a match where B1 is each item i
the list of 3000 items and A:A is the 10000 item list.

You can then sort or filter to get the N/A's and see the missin
entries and copy them out.

Dunca
 
F

Frank Kabel

Hi
if your list of 3000 entries in on sheet1 in col. a and
your secondf list on sheet2, col. A try the following:
- enter the following formula in B1 on sheet1
=IF(COUNTIF('sheet2'!$A$1:$A$12000,A1)=0,"X","")
- copy this formula down
- after this use 'Data - Filter - Advanced Filter' and
choose only the entries with an 'X' in column B. Select a
different range as target for advanced filter
 
D

DNF Karran

You put it next to each item in the list of 3000 entries and make th
"b1" part the item it is next to. ie:

If you were to arrange things as in Franks' example with the list o
3000 entries on sheet1 col a starting at line1 and the 10000 entry lis
on sheet2 col a you need to input the following to sheet1 col b line
and copy it down alongside the whole list on sheet1.

=VLOOKUP(A1,Sheet2!A:A,1,FALSE
 
F

Frank Kabel

Hi
what does not work?
Do you get an error or what happens as these procedures
should do :)
 
D

dancingbear72

When I copy the formula into b1 on sheet 1 it ends up being in c1? an
doesn't do anything when I try to copy it down. What am I doing wrong
 
F

Frank Kabel

Hi
didn't understand the first part?
If you copy it into cell B1 how does it end in C1?
 
D

dancingbear72

I don't know, but it does. I've closed it and tried it again about 1
times and it keeps doing it?
 
D

dancingbear72

Ok, sorted that problem now, it was my spreadsheet playing up. Stil
can't get it to work though. If I do Franks' suggestion it doesn't sho
any Xs, if I do the other one it just copies the whole of column a t
column b
 
F

Frank Kabel

Hi
if you like email me your file and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de
 
Top