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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 8 Dec 2012 à 14:20
Related:
- How to find missing numbers in a seperate column from 2 columns
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- How to delete a column in word - Guide
- Excel column number - Guide
- Missing image icon - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
8 Dec 2012 à 14:20
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, "")
in c2,
=IF(ISERROR(MATCH(b2,a:a,FALSE)),b2, "")
in d2
=IF(ISERROR(MATCH(A2,B:B,FALSE)),A2, "")