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

[Closed]
Report
Posts
1
Registration date
Saturday December 8, 2012
Status
Member
Last seen
December 8, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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>

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
one way could be
in c2,
=IF(ISERROR(MATCH(b2,a:a,FALSE)),b2, "")

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