Remove duplicates across two worksheets

Hello all!

I have 4 columns of data in a worksheet (A-D). It goes as follows:

| Control # | FirstName | LastName | Email |

I have a second sheet with the same format, and a lot of duplicates. What I would like is to remove all the data from sheet 2 that is also on sheet 1. Is there a simple way to do this? the list is extremely long and would be a nightmare to do manually. I would appreciate any help.

Thanks!

When you say duplicates in sheet2, does that mean they are already on sheet1? Or that you have things in sheet2 showing up multiple times in sheet2?

One thing you could do is add a new column in sheet2. Combine all 4 fields together (=A1&B1&C1&D1). This will create a unique lookup field (assuming there is nothing in sheet2 that's repeated more than once

In sheet1 next to your data, do =vlookup(A1&B1&C1&D1,2,0). If something shows up, it means it's found it in sheet2. If you get a #N/A, that means it's not in sheet2. After that, you can quickly filter on just the #N/As and that's your data that isnt in sheet1.

I can post an example if you need further help!

I just combined them and removed duplicates. I'm not sure why I couldn't think of that on my own. Friday fever maybe? Anyway thanks for the help guys, I really appreciate it.