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

we have 2 email lists have been "mixed" mistake.

the first column has:

• email addresses want
• as aso don't want there.

the second column has:

• the email addresses aren't needed
• and want extract column 1.

is there simple way delete duplicates , delete unwanted email addresses column 1 too?

i hope can understand ramble.

for duplicate part :

go "data" tab , click "remove duplicates", having selected columns. 

for data not want, might need "filters" if understood problem.

go "data" tab, click "filters" , select data want, delete rows.