How to remove duplicate rows in Excel?

Question

excel

There is a list of emails from one customer base (6200), and there is a list from another database of the same customer (674)
We sent an email to the second base (674), but the first list contains emails from the second list
How to remove completely e-mails from the second list from a large database, so that there are those to whom we did not send letters? I don’t want to disturb people a second time. It’s
possible not through Excel, but through another program

Answer 1

Make a backup!
1 - Copy both sheets into one workbook
2 - Sort both lists in ascending order by email field
3 - Use VLOOKUP for large list, search in small
4 - Enable filtering and filter all found values
​​5 - Delete all filtered ones