Hi Everyone,


I am trying to find a way to compare two columns of numbers. Eac
column contains about 2,500 rows of numbers and I want to know wha
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 foun
so far compare the rows side by side. I dont care about the order th
numbers are in.

Thank

--
Patty
-----------------------------------------------------------------------
PattyB's Profile: http://www.excelforum.com/member.php...fo&userid=1473
View this thread: http://www.excelforum.com/showthread.php?threadid=26353