Comparing 2 lists side by side

P

petevang

I have two lists of data in columns A and B. I'd like to see which
cells do not appear in column B that are listed in Column A. Any idea
how to do this? For example:
A B
1 1
2 3
3 5
4 7

I'd like to be able to see that 2 and 4 do not appear in column B

:) :) :)
 
S

SteveG

You could use conditional formatting. In A1 use the Formula is optio
in conditional formatting. Use this formula.

=COUNTIF($B$1:$B$9,A1)=0

Click on Format, Patterns, and select a color to fill in the cell t
identify it as not being found. Click OK, OK. Use the format painte
to apply to the rest of your cells in A.

HTH

Stev
 
Top