Hi there and thanks in advance for any help.
How do you delete entire rows based on duplicates in certain columns? I want to search for duplicates in column C and D and then delete entire rows where this occurs. Example, in the sheet below I want to delete row number 4. Obviously we are talking about sheets where there are thousands of rows. Need a quick way to either isolate or auto delete these rows please.
Capture01.PNG
Here is one way
Please Login or Register to view this content.
Last edited by gmr4evr1; 12-18-2017 at 08:45 PM.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Sorry, my fault...I actually have 5 columns A-E and it's columns D and E I want to check duplicates in. Possible to rewrite the code for me please? Thanks so much for your time!Originally Posted by gmr4evr1
Here is one way
Please Login or Register to view this content.
Try changing
toPlease Login or Register to view this content.
Please Login or Register to view this content.
It worked! Thanks so much, you've saved years of my life!Try changing
toPlease Login or Register to view this content.
Please Login or Register to view this content.
No problem, glad it worked for you. Thanks for the rep
To avoid errors(matching rows that didn't get deleted) deleting rows is always done from bottom to top or in 1 go using specialcells.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I need to modify this a bit. I realized I need to go through the results instead of deleting the rows straight away. Now I need to do the same thing but instead of it auto deleting the rows I need to put a value 1 in column F if there is a row match in columns D and E. This will allow me to then sort the whole sheet by column F and I can go through the results to then delete the rows I don't want manually.No problem, glad it worked for you. Thanks for the rep
Possible?
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by bakerman2; 12-19-2017 at 05:03 AM.
Pure brilliance!!
(The 1 got input into column G rather than column F but it's all good!)
Thanking you kindly.
Glad to help. Thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks