Duplicate entries

[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

 

[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

 

[Bernard V Liengme]

Have a look at Chip's site www.cpearson.com. He has lots of good stuff on
duplicates
Bernard

 

[dancingbear72]

Thanks. Where do I put the =VLOOKUP(B1,$A:$A,1,FALSE) bit

 

[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

 

[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

 

[dancingbear72]

dead link mat

 

[dancingbear72]

None of this seems to work, is there a macro I can use

 

[Frank Kabel]

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

 

[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

 

[Frank Kabel]

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

 

[dancingbear72]

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

 

[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

 

[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

 

[dancingbear72]

Thanks Frank I'll do tha