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.

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.

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.