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

HTH
--
AP

"petevang" a écrit
dans le message de
...

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