software

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: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=530913In C1 enter:
=ISERROR(MATCH(A1,B$1:B$4;0))
and drag down to C4

HTH
--
AP

quot;petevangquot; gt; a écrit
dans le message de
news
gt;
gt; I have two lists of data in columns A and B. I'd like to see which
gt; cells do not appear in column B that are listed in Column A. Any idea
gt; how to do this? For example:
gt; A B
gt; 1 1
gt; 2 3
gt; 3 5
gt; 4 7
gt;
gt; I'd like to be able to see that 2 and 4 do not appear in column B
gt;
gt;
gt;
gt;
gt; --
gt; petevang
gt; ------------------------------------------------------------------------
gt; petevang's Profile:
www.excelforum.com/member.php...oamp;userid=25034
gt; View this thread: www.excelforum.com/showthread...hreadid=530913
gt;

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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=530913