| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
identify cells containing identical values in two columns
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 --------------- Jacob Skaria "sherehind" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Addition of identical numbers to cells with different values. | Excel Worksheet Functions | |||
| Adding up cell values only with identical info in other cells | Excel Worksheet Functions | |||
| Looking Up Datas when Key Values are Identical | Excel Worksheet Functions | |||
| How to Identify Values in Common Between 2 cells | Excel Discussion (Misc queries) | |||
| How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) | |||
Threaded Mode
