unique data

[Gary]

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]

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]

Myrna,

That's what I needed. Thanks.

Gary

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.