in C1 put in the formula
=if(countif($B:$B,A1)=0,"Only in A","")
in D1 put in the formula
=if(countif($A:$A,B1)=0,"Only in B","")

then select C1 and D1 and drag fill down the column.

You can then apply an autofilter to column C and then Column D, each time
copying only the visible cells in A, then B

--
Regards,
Tom Ogilvy


"PattyB" wrote in message
...

Hi Everyone,


I am trying to find a way to compare two columns of numbers. Each
column contains about 2,500 rows of numbers and I want to know what
numbers appear in one column and not the other.

Ex:

Column A Column B

1234 3424
4324 4324
5435 5345
6564 1234
3242 6546
5435 7657


I want to know two things:

1. What numbers appear in Column A and not in Column B.
2. What numbers appear in Column B and not Column A.

Is there anything out there that can do this? Most things I have found
so far compare the rows side by side. I dont care about the order the
numbers are in.

Thanks


--
PattyB
------------------------------------------------------------------------
PattyB's Profile:
http://www.excelforum.com/member.php...o&userid=14734
View this thread: http://www.excelforum.com/showthread...hreadid=263531