CODEWITHSUNDEEP
excelvba
Alex Gordon
Alex Gordon

Reputation: 60871

excel - remove rows where duplicate entry in field exists

is it possible to with a formula or vba to delete an entire row where some string exists in a field

for example, if A1 has "string1" and A234 has "string1" then i want to keep only 1 of that row

Upvotes: 2

Views: 3339

Answers (3)

BeemerGuy
BeemerGuy

Reputation: 8279

I had a hunch that you're just looking to delete rows without necessarily making a macro. My solution to this one-time issue is to manually use the Remove Duplicates feature of Excel 2007+ under the Data tab; some people overlook this quick-and-painless feature.

Upvotes: 3

TerrorAustralis
TerrorAustralis

Reputation: 2923

If you want to create a distinct list...
Select the data you want, and in the Filter section go Filter => Advanced. Then select Copy to new location, distinct records only.

That will copy a distinct list of the selected records to your chosen location

Upvotes: 1

icyrock.com
icyrock.com

Reputation: 28628

Here's a post that contains a function you are looking for:

There are multiple functions here, take a look at DeleteDuplicateRows.

You can find another one here:

Hope this helps.

Upvotes: 1

Related Questions