Comparing 2 lists side by side

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

In C1 enter:
=ISERROR(MATCH(A1,B$1:B$4;0))
and drag down to C4

HTH
--
AP

"petevang" <petevang.25wbvz_1144416606.206@excelforum-nospam.com> a écrit
dans le message de
news:petevang.25wbvz_1144416606.206@excelforum-nospam.com...
>
> 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
>
>
>
>
> --
> petevang
> ------------------------------------------------------------------------
> petevang's Profile:
http://www.excelforum.com/member.php...o&userid=25034
> View this thread: http://www.excelforum.com/showthread...hreadid=530913
>

You could use conditional formatting. In A1 use the Formula is option 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 to identify it as not being found. Click OK, OK. Use the format painter to apply to the rest of your cells in A.

HTH

Steve