Excel Bulk Duplicate Find and Delete

I have large a amount of data and I am having some issues with duplicates within the list. Basically, my list looks like this:

Mobile Fname Sname
7700900330 Cora smith
7700900917 bob jane
7700900881 jake hardy
7700007311 larry malone
7700900748 harry jordan
7700900675 martin mchardy
7700900917 sarah jane


I want to be able to run a macro or write a formula which will look at collumn A and check for duplicates. As you can see in row 3 & 8 have the same mobile number but different people. I want to be able to run the macro so that it will look at all of collumn A and see that number 7700900917 appears twice and delete all of row 3 or 8 leaving one unique record. The reason i am trying to automate this, is because my records are over 800,000 and this will take much time. Also, data is not original data for DPA purposes.

I hope my explanation of what I am attempting to achieve makes sense.

Thankyou for any assistance you are able to provide.

If you want to delete all 3 columns try

Please Login or Register  to view this content.

Thanks Mumps1

This is sort of working, but it seems to find the duplicate and delete it and shift all of collumn A's numbers up rather than deleting the row containing the duplicate?

Again thanks for your assistance.

What logic applies to which of a duplicate gets deleted??

Please Login or Register  to view this content.

You can clear data and return data from temp sheet to original sheet

Thanks nigelog,

Ive tested the code you provided and it seems to work well. With regards to your question, it does not really matter which of the rows are deleted with duplicate numbers, as long as if there were two of the same records with same numbers, that one of them was deleted.

A couple of questions if i may:
If for some reason a record appeared three times with the same number, would two of the rows be deleted?

also, when I tested the code the first time it worked, but when attempting to input new raw data and test the code again I get 'Run-time error 1004', any ideas?

Thanks again for your help, its much appreciated.

Did you try my suggestion in post#3?

temp page probably exists no error trap for that