identify cells containing identical values in two columns

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
Identify Duplicates that are not identical 4
Finding matching numbers from 1 worksheet in another and with a tw 1
Merging Data from two rows into one 1
Combination of INDEX MATCH FREQ ROW INDIRECT - find unique values using2 conds with UIDs that may ha 0
Identify letters but not spaces 2
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
choose last cell with a value in a column 8

Top