identify cells containing identical values in two columns

  • Thread starter Thread starter sherehind
  • Start date Start date
S

sherehind

I have two sets of serial numbers. One is genarated by system and other one
is physically scanned number.

I have them in two columns and want to identify which serial numbers are
missing from either column

I am sure it is pretty easy but I can't seem to figure it out.

Thanks
 
Col A and Col B are serial numbers and Col C will reflect the numbers which
are missing referring to ColB

Col A Col B Col C
1001 1061 =IF(COUNTIF(A:A,B1),"","Missing in A")
1002 1062 Missing in A
1003 1063 Missing in A
1004 1001
1005 1004
1006 1005
1007 1067 Missing in A
1008 1068 Missing in A

If this post helps click Yes
 
Back
Top