CODEWITHSUNDEEP
excelms-officeexcel-2016
fas
fas

Reputation: 103

Compare two columns in excel and remove duplicates

I have this two columns of names:

Column 1         Column 2

A                  B
B                  D
C                  E
D
E

I need to compare the two columns and have in output the values that are in Column 1 but not in Column 2, so the output must be:

Column 3

A
C

How can I achieve that?

Thanks

Upvotes: 0

Views: 5610

Answers (1)

Gary's Student
Gary's Student

Reputation: 96791

In C1 enter:

=IF(COUNTIF(B:B,A1)=0,A1,"")

and copy down.

enter image description here

The blanks can also be removed, if necessary.

Upvotes: 2

Related Questions