How to find missing numbers in a seperate column from 2 columns

Closed
bhatt.1983 Posts 1 Registration date Saturday December 8, 2012 Status Member Last seen December 8, 2012 - Dec 8, 2012 at 02:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 8, 2012 at 02:20 PM
Hello,

I have data in 2 columns (given below) and want to compare both the columns and want to get the missing numbers in seperate column. e.g
Column 1 Column 2
1 6
3 7
5 7
7 3

I want to compare both the colunms and want to get the numbers in column 3, which are not in column 1 but are in column 2. And numbers in column 4, which numbers are not in column 2 but are in clumn 1.

I hope question is clear.

Regards,
Sudhir


config>Windows 7 / Internet Explorer 8.0</config>
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 8, 2012 at 02:20 PM
one way could be
in c2,
=IF(ISERROR(MATCH(b2,a:a,FALSE)),b2, "")

in d2
=IF(ISERROR(MATCH(A2,B:B,FALSE)),A2, "")
0