Removing All Entries if Duplicate Value (picture)

[cmf0106]

I have a large database. In the database I need to remove anyone that appears more than once in the database, not just the duplicates, but all of the entries period.

For example in the image from the database below I would need to remove all entries with the owner_address "6040 Camp Bowie Blvd Ste 38". There would no longer be an entry with that address after the query because it occurs more than once in the database.
owner_address3.jpg

How might I go about tackling this?

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[MarvinP]

Hi Cmf,

Easy enough problem. You need to create a helper column and count the number of things that match your address. Then sort your data by this helper column and delete all rows that have this helper column greater than 1. Here is a sample of what I mean....