How to compare columns in excel with output of non-matching cells?

E

Evgeny Zhurov2017-10-25 14:03:10

excel

Evgeny Zhurov, 2017-10-25 14:03:10

Good afternoon. There are two columns that can contain duplicate data (column B can contain data from column A and vice versa). What formula will compare both columns and output data in column C that is NOT duplicated. That is, it will display those cells from column A that are not in column B and those that are in B, but not in A. If possible without macros, then it is better without them.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Fedoryan, 2017-10-25
@Zhuroff

www.planetaexcel.ru/techniques/2/99