| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare two columns contents for differences | Excel Worksheet Functions | |||
| How to compare worksheets so differences are identified | Excel Worksheet Functions | |||
| Compare two columns by aligning same-values and spacing out differences | Excel Worksheet Functions | |||
| How do I compare 2 text columns & show differences in 3rd? | Excel Worksheet Functions | |||
| Compare 2 columns to see differences | Excel Worksheet Functions | |||
Linear Mode
