Answer the question
In order to leave comments, you need to log in
How to remove duplicates in 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 the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question