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

Closed
bhatt.1983 Posts 1 Registration date Saturday 8 December 2012 Status Member Last seen 8 December 2012 - 8 Dec 2012 à 14:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 8 Dec 2012 à 14:20
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
8 Dec 2012 à 14:20
one way could be
in c2,
=IF(ISERROR(MATCH(b2,a:a,FALSE)),b2, "")

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