compare two columns and pull out differences

A

Anna

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!
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Setting column width in a table with a macro is not working 0
Two columns followed by single page-width column on same page 0
How to center adjust text above and image in a two column document. 1
Two columns : Continuous two columns vs Parallel two Column 1
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Excel does not accept text format! 0
Columns appearing from nowhere, formatting going weird 0

Top