If you think so, then fine. The macro I've posted above in post #5 is to delete rows based on a single column choice. In that one I chose "M" because it appears to be a unique customer code.
If you change all the "M"s to "D"s it would work off that column. I ran it with "M" and "D" as the column choice and it appears to give the exact same results. Up to you to change it if you wish. This is ready to use once you settle on which column and insert the macro into a standard module.
1. Open up your workbook.
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet.
Then press Alt-F8 and select the DeleteDupesByCountif macro.
Bookmarks