I have an Excel sheet (File 1) with huge employee data running into tens of thousand of rows. Sometimes I get sent another spreadsheet (File 2) with a few hundred employee data and I am asked to find if these employees exist in my database based on their name, mobile and email. Now I cannot run a vlookup because it will only pull out the same name from File 1, but it won't necessarily be the same employee. I need a macro to compare the name, phone, email for an employee in File 2 and tell me if there is an employee with the same details in File 1. These criteria keep changing too, sometimes I am asked to compare based on Surname, Maiden Name and so on...

Macro to find duplicates based on more than one column

Don’t have an account yet? Register yourself now and be a part of our community!

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.