Im trying to delete duplicates in excel from two columns AND also delete the original too

Question

We have two email lists that have been "mixed" by mistake.

The first column has:

• email addresses that we want
• as well aso some we don't want there.

The second column has:

• the email addresses that aren't needed
• and that we want to extract from column 1.

Is there a simple way to delete the duplicates and also delete unwanted the email addresses from column 1 too?

I hope you can understand my ramble.

Answer 1

For the duplicate part :

Go to the "data" Tab and click "remove duplicates", having selected the columns.

For the data you do not want, you might need "filters" if I understood well your problem.

Go to the "data" Tab, click "filters" and select data you want, delete the rows.