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
 

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

Identify Duplicates that are not identical 4
choose last cell with a value in a column 8
Identifying missing numerical values in a series 6
nesting functions to compare segments of two columns 1
Finding matching numbers from 1 worksheet in another and with a tw 1
Excel Comparing two columns 1
counting identical items in a column and returning the occurrences 3
Macro to push data to another workbook 0

Back
Top