excel formulate find duplicate in a column and erase full row

Job ID: 33043965

Budget: $10 – $30 USD

Hi, I need a formula that will select all the duplicates in a specific column and from there delete the row where the duplicates are.

So if duplicate is is B1 and B2 it will erase row the full row #2
Related categories: Data Processing Data Entry Excel Excel VBA Excel Macros