I think I'd just insert two columns--a new column B and a new column D.

Then in B1:
=if(isnumber(match(a1,c:c,0)),"In Column C","Missing from C")
and drag down

Then in D1:
=if(isnumber(match(c1,a:a,0)),"In Column A","Missing from A")
and drag down

Then I'd insert a new header row in row 1.
Select A:D
Data|filter|autofilter

Then I could filter to show the missing and copy those visible cells whereever I
wanted. (Yeah, I'd have to filter twice to get both columns.)

Keith wrote:

H ave two columns of Serial #s like (A26B3 or 125R6F) I need to I compare the
two columns to see where the differences are. I think I need to say IF A1 is
contained in column B then copy the contents of A1 to C1. IF A1 is not in
column B copy A1 to D1.---Repeat, repeat repeat and IF B1is not in column A
the place B1 in E1. ---repeat, repeat repeat.

I need to find out where both scanner (human error on input) errors are as
well as Inventory errors (human keboard input) are, be cause Im driving
myself nuts trying to find out which serial#s are in which column and which
are not, can any body think of how i could pose the argument (even if its not
excel, but say access) so that I can do this

Keith

--

Dave Peterson