Create a Macro for identifying duplicate

[AnilVaish]

Hi All,

I have list of 1Million contacts which contains Company Name, Contact First Name, Contact Last Name, Contact Full Name and Email address.
I want to source another 100k contacts from the same companies but it should be unique contacts, should not match the existing ones. But i source contacts in a bulk. I want someone to create a macro which should identify the duplicates from the million database. It should use a logic of (Company + Full Name) and shows value as duplicate.
Thanks for the help!

 

[skillilea]

Have you looked at power query? You can pull your data into PQ and it will do this for you quite easily.

Data Tab / From Table Range.

 

[Joe4]

Welcome to the Board!

Yeah, I think it might be pushing the limits to try to do this with the traditional Excel methods.
If not Power Query, I would opt for a relational database program like Microsoft Access, which handles these kind of relational database questions much more gracefully than Excel does.

 

[AnilVaish]

Hi,
Can you please help me with the same in Power query. I dont have any idea.

Have you looked at power query? You can pull your data into PQ and it will do this for you quite easily.

Data Tab / From Table Range.

 

[skillilea]

I agree with Joe4 above about leveraging the power of a database. SQL or Access.

But, if you highlight your data and click on Data/From Table/Range.
Excel will ask you to create a table if it's not in one. Do that.
Then you will see this.

Maybe start with a subset of data to get familiar with the tool.

 

[AnilVaish]

Hello All,
I dont want to remove duplicates, i want to identify which records are duplicate. Can someone help me with power query OR MS access.

 

[skillilea]

This will show you how to do what you want in PQ

Identify duplicates

 

[Joe4]

Hello All,
I dont want to remove duplicates, i want to identify which records are duplicate. Can someone help me with power query OR MS access.

See here: Find duplicate records with a query - Microsoft Support