Remove duplicate row if cell is blank

Hi,

I am back again to seek some experts help. I have below code which checks duplicates in column B & C and remove the entire row.
Is it possible that if duplicate found macro should remove row which have blank cell in column D?

Please Login or Register  to view this content.

Thanks Jeffrey,

This code is deleting all the rows if cells in column D are blank. I am sorry if I was not very clear in my 1st post.
The DelDup code is deleting the second instance if duplicate found. For example values in cell B2 & C2 are identical with values in B10 & C10 so it will delete row 10. However I want that it should check cell D2 & D10, if D2 is blank then it should delete row 2 instead of row 10. IF D10 is blank then delete row 10 and if D2 & D10 both are blank or non-blank then it should delete row 10.

Hope I am clear... sorry, I am not so good with vba.

Is it possible??

Hi,

In the attached file row 3 and row 10 have identical values in column B & C, the macro in post 1 will delete row 10 however I need that it should check column D in both rows and delete the row which have blank cell, if both rows have blank cell or if both rows have values in column D then delete row 10

If it is possible, this will be big help for me, since I used to work on 25000 - 30000 rows of data 4-5 times a day.

Thanks in advance.

Thanks for your efforts, Jeffrey

The above macro is not deleting any row if both rows have values in column D and deleting both rows if cells are blank in column D

We are close but not yet

Originally Posted by leelnich

Or this - Sort and Remove Duplicates:

It will be easy if OP is not on 2003...

TRUE - Thanks for pointing that out. RemoveDuplicates was intro'd Excel 2010. I'll leave it as useful for later versions.

Thanks leelnich, jindon, mike7952 & jeffrey for taking your time out and providing the solution.

I have adopted leelnich code with a small change in one line

Please Login or Register  to view this content.

this dosent mean that other's code dosent work but with my limited knowledge of VBA I found leelnich's code is easiest to modify to fulfill my need.

As always you all are rockstar
Many Many Thanks

Happy to help!, but I have to ask: Did you note my (and jindon's) remarks re: Office version. According to your profile, seen to the left of your posts, you use Excel 2003. The RemoveDuplicates method WILL NOT WORK with that version, as it was introduced in 2010. If you have updated, you should amend your profile to reflect that, as we use that info to tailor our answers to YOUR version - unless we miss it, as I did . -Lee

Yes leelnich... I do use office 2010 and updated this info in my profile... thanks so much

Marked this thread as SOLVED.

Thanks everyone!