ExcelBanter - Compare data in two columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Compare data in two columns (https://www.excelbanter.com/excel-worksheet-functions/105696-compare-data-two-columns.html)

excellearn2006

Compare data in two columns

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other

salut

Compare data in two columns

Match(B1,A:A,0)

"excellearn2006" wrote:

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other

excellearn2006

Compare data in two columns

Let's say I have 10 records for column A and 20 records for column B. What if
I wanted to list all the records in column B that do not match with column A-
in column C.

"salut" wrote:

Match(B1,A:A,0)

"excellearn2006" wrote:

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other

All times are GMT +1. The time now is 11:38 AM.