Deleting Duplicates!!

Hi,

I am new to these forums and I hope someone can help me with my excel issues. Here is what I am basically trying to do with excel 2010.
I have 30,000 records with employee id column A, last name column B, first name column C, and Card code in column D. I want to compare duplicate records which match all 4 columns and if there is a match delete those two rows.

So if ROW X of column A AND column B AND column C AND column D Match Row Y of column A AND column B AND column C AND column D, delete the record. All i want is that if two records match with all of those rules then delete both matches in the rows.

Thanks again hopefully someone can help!

Mel

Hey Ace,

I already tried that, it only deletes one of the duplicates not BOTH. Any other thoughts?

Hey Ace,

I don't want to sound stupid, but I am really new to excel. Please clarify what I am suppose to do with this "=COUNTIFS(A:A,A2,B:B,B2,C:C,C2,D:D,D2)>1". I didn't really understand what you meant by use it on row 2 and mark it as true. Do I just copy and paste that under any row2 and then drag it down? Then do I highlight all four columns and delete duplicates?

Sorry for the ignorance!

I tried the formula and unfortunatley it shows false for everything. I uploaded a sample from the large file I have to show you what I'm trying to do.

As you can see line 2 and 3 have the same information, I want something to compare the two rows and if its the same value delete it. If I run the duplicate remover from excel it will still leave a copy of one of the rows.

To give you a bigger picture here is what it should do. If you go to emp#677, the last name and first name dont match but the card code does. If we can get rid of the rest of the duplicates at the end all of my results would be the the columns that do not match and I would be able to tell which peoples names are not with the right card codes.

Thanks

Awesome now it shows true and false. So the next step is how to delete the Both Duplicates?

Thanks Ace u rock!