Delete rows based on duplicate names in 1 column if they contain a value in a second ?

**myk2thestar23** · 01-25-2017, 04:12 AM

I need to know if it is possible to delete all rows with duplicate names in column A if Column B contains a value for any of those rows with that same name?

Example Below: I need to be able to delete ALL rows below that have the name "APPLE" in Column A if any of those rows contains a "1" in Column B. So in this case, ALL 4 rows with "APPLE" need to be deleted even though the first row with "APPLE" doesn't contain a "1" in Column B. The same goes for name "DOG".

Column A Column B

BOOK
BOOK
APPLE
APPLE 1
APPLE 1
APPLE 1
CAT
CAT
CAT
CAT
DOG 1
DOG

**Keebellah** · 01-25-2017, 04:25 AM

Try this code, place it in the worksheet module

Please Login or Register  to view this content.

**myk2thestar23** · 01-25-2017, 04:34 AM

Thank You!!! You just saved me lots of manual hours of work. Doing this manually already took me 3 hours and I still have 2,000 + more rows to go through. This is working perfect!! Thanks again!!

**Keebellah** · 01-25-2017, 04:46 AM

You're welcome.
Don't forget to mark the post solved

**myk2thestar23** · 01-25-2017, 02:47 PM

Keebellah, I'm sorry. After running the macro on the huge spreadsheet, it didn't delete all the rows I expected. Did I do something wrong? I need it to delete all rows of the same name in Column A, even if column B only has one row with a "1" in it for that same name in Column A.

Example Below: I need it to delete ALL the rows with the name "Cat" even though 3 of the rows don't have a "1".

Column A.........Column B

Cat................1
Cat................
Cat................1
Cat................
Cat................

**JOHN H. DAVIS** · 01-25-2017, 03:45 PM

Maybe:

Please Login or Register  to view this content.

**myk2thestar23** · 01-25-2017, 03:57 PM

Thanks John, I am running it now. It seemed to work on a small worksheet. I am running it on the big one. I really appreciate the help. It will definitely save me a lot of manual work! I'll post once it finishes running. I have over 30K rows

**Keebellah** · 01-25-2017, 04:51 PM

That was NOT what you asked .... but I see you've got another answer.

Delete rows based on duplicate names in 1 column if they contain a value in a second ?

LinkBack

Thread Tools

Rate This Thread

Display

Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Re: Delete rows based on duplicate names in 1 column if they contain a value in a second ?

Thread Information

Users Browsing this Thread

Similar Threads

Delete Duplicate rows with duplicate in 1 column based on value from another column

Delete Duplicate rows with duplicate in 1 column based on value from another column

[SOLVED] Vba to sum up rows based on column a & b and delete duplicate rows

highlight duplicate rows and delete based on highest value from column

[SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.

how to delete rows based on duplicate information in a column

[SOLVED] delete duplicate names in a column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions