How to remove douplicated rows with blank cells

Hi everyone

I have a new issue with removing whole rows with blank cells.

Attached you will find an example of a spredsheet im working on. There are duplicated ROWS which i have to replace with blank cells to keep it in line...

I did that with specific cells, .if(, but im not sure how to do it exactly when i have to remove/replace the whole row.

Please help me out with this issue

Many thanks in advance!DUPES_example.xlsx

I added a column to check for matches. Could you just filter on "Yes" and then delete the contents of the duplicate rows without deleting the whole row?

Please Login or Register  to view this content.

Thanks for that quick reply, hoyasaxa215. Probably i forgot an important info. Lets say that it could be that in column a it could be a different ZR nr. but the rest Column B:K same information's. In this case it should be removed... its meant that i would have to "filter" it by several criterias.

P.s. Most important are column F:G - as per att. you will see they're all the same

Many Thanks!

Hi ranman256

Here again - as i see your range is just A2 - but i think that def the way i should go... even if im absolutely new with macros.

it should run on column F:G as described on my previous comment.