ExcelBanter - Comparing Data in 2 columns

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

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

- - Comparing Data in 2 columns (https://www.excelbanter.com/excel-worksheet-functions/8700-comparing-data-2-columns.html)

suzb

Comparing Data in 2 columns

I'm comparing data in 2 columns. I need to find unique cells that are located
in Column B that are not in column A.

JE McGimpsey

Take a look at

http://cpearson.com/excel/duplicat.htm

In article ,
"suzb" wrote:

I'm comparing data in 2 columns. I need to find unique cells that are located
in Column B that are not in column A.

Myrna Larson

In column C, put this formula:

=IF(COUNTIF($A$2:$A$100,B2)=0,"X","")

and copy it down

This will show an X next to the items in column B that aren't in column A.

On Wed, 5 Jan 2005 09:07:04 -0800, "suzb"
wrote:

I'm comparing data in 2 columns. I need to find unique cells that are located
in Column B that are not in column A.

All times are GMT +1. The time now is 07:01 AM.