Prev: cell data management
Next: Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
From: Anna on 11 Feb 2010 10:55
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!
From: Luke M on 11 Feb 2010 11:16
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!
 | 
Pages: 1
Prev: cell data management
Next: Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute