vlookup the pain of my life!!

[chrisgrove121]

hey guys, please help!!

in column A i have 200,000 telephone numbers
in colum B i have 130,000 telephone numbers (which are also in column A)
i want the 70,000 unique records to appear in column c.

if anyone can help i will be forever in your debt!

 

[James006]

Hi,

If you are using Excel 2007 ... go to Data > Remove Duplicates

HTH

 

[chrisgrove121]

umm i dont think thats what will work.

column a has 200,000 records in (130,000 which are in column b and 70,000 unique records)
column b has the said 130,000 records in
i need to take out the 70,000 unique records and put them in column c

many thanks

 

[njimack]

You can easily determine whether a value in column A is also in column B, using COUNTIF in a helper column:

=COUNTIF(B:B,A2)>0

Then filter this column to display TRUE, and voila! Use Goto>Special to copy just the visible cells.

 

[Verald]

umm i dont think thats what will work. column a has 200,000 records in (130,000 which are in column b and 70,000 unique records) column b has the said 130,000 records in i need to take out the 70,000 unique records and put them in column c many thanks

put this in cell C1. =IF(ISERROR(VLOOKUP(A1,B:B,1,FALSE)),"unique","duplicate") Then filter column C for only values which are unique

 

[James006]

Hi,

With 200'000 records ... move all your records in column A and apply Data > Remove Duplicates