Hi there!
I am looking for a best way to remove rows with duplicates base on values from a specific column (let's say column D for e.g.), but I would like to leave whole blank rows (do not treat them as a duplicate). Right now I'm using built-in Excel "Data --> Remove duplicates" and I'm selecting a column on which I want to base my removing process and additional column in which formula
fills blank lines with increasing numbers so Excel don't treat those lines as a duplicate.
My solution is working, but I feel like it's more like work around the problem and not dealing with the problem directly.
Maybe someone will have some ideas how to solve this case in a better way?
Best regards,
Tom.
I am looking for a best way to remove rows with duplicates base on values from a specific column (let's say column D for e.g.), but I would like to leave whole blank rows (do not treat them as a duplicate). Right now I'm using built-in Excel "Data --> Remove duplicates" and I'm selecting a column on which I want to base my removing process and additional column in which formula
VBA Code:
=IF(LEN(TRIM(A1))=0,ROW(),"")My solution is working, but I feel like it's more like work around the problem and not dealing with the problem directly.
Maybe someone will have some ideas how to solve this case in a better way?
Best regards,
Tom.
