unique data

Gary · Aug 31, 2003

Data exists in cells A1 thru A55705.
Data exists in cells B1 thru B51315.

How can I find the data in the cells in column "A" that do NOT match
the data in the cells in column "B"?

Myrna Larson · Aug 31, 2003

I would do it this way:

Put this formula in C1: =IF(COUNTIF($B$1:$B$51315,$A1)=0,"X",""). Copy down through C55705.
You'll see an X for the unique items. You can use AutoFilter on column C to display only the
rows with an X.

Gary · Sep 1, 2003

Myrna,

That's what I needed. Thanks.

Gary

Myrna Larson said:
I would do it this way:

Put this formula in C1: =IF(COUNTIF($B$1:$B$51315,$A1)=0,"X",""). Copy down through C55705.
You'll see an X for the unique items. You can use AutoFilter on column C to display only the
rows with an X.