A
A
Andrey Kulagin2019-02-27 12:09:30
excel
Andrey Kulagin, 2019-02-27 12:09:30

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

2 answer(s)
S
shushpanio, 2019-02-27
@andrew_1985

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

P
Pychev Anatoly, 2019-02-27
@pton

screenshoter.ru/s/270219/Gs2yzkgG

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question