How to remove duplicates in Excel?

Question

excel

Hello! Can someone tell me, I can’t delete duplicate emails in Excel, the essence is this, there is column A and column B, in column B there are emails that are found in column A, you need to display in column C those emails that are not found in column A , but it is in column B, I couldn’t google it, thanks to everyone for the advice. Now I manually check each email in column B to see if it occurs twice, but it takes a long time. I can’t immediately select both columns and remove duplicates with a standard function, since the data in column A is used

Answer 1

do the following:
1. in Column C for each cell from column B we write the formula (example for C1) =VLOOKUP(B1;A:A;1;0)
2. put filters on a pair of columns B and C and select N/A values in column C
3. The result of filtering from column B is what you need

Answer 2

screenshoter.ru/s/270219/Gs2yzkgG