# vlookup the pain of my life!!

#### chrisgrove121

##### New Member

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!

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### James006

##### Well-known Member
Hi,

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

HTH

#### chrisgrove121

##### New Member
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

##### Well-known Member
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

##### New Member
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

##### Well-known Member
Hi,

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

Replies
0
Views
101
Replies
4
Views
82
Replies
2
Views
172
Replies
20
Views
426
Replies
1
Views
220

1,195,906
Messages
6,012,234
Members
441,685
Latest member
12345695959

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back