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

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

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530913