compare two columns and pull out differences
 

I have two columns of numbers. I want to know the numbers that do not have a
match or are not in both columns. But I need all of each column to be
compared to all of the other column...not cell by cell. It would be great if
I could pull out the differences and put them in a different column. Looking
at two long lists of numbers to pull out the different number is very time
consuming! Thanks for any help you can give me!

compare two columns and pull out differences
 

To check column A against column B:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"",A2)

vice versa:
=IF(ISNUMBER(MATCH(B2,A:A,0)),"",B2)

Any number listed has not been found in the corresponding column.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Anna" wrote:

I have two columns of numbers. I want to know the numbers that do not have a
match or are not in both columns. But I need all of each column to be
compared to all of the other column...not cell by cell. It would be great if
I could pull out the differences and put them in a different column. Looking
at two long lists of numbers to pull out the different number is very time
consuming! Thanks for any help you can give me!