Need to find missing items in a column

[techie2013]

I have two column with almost same data. However, a few IDs are missing in one column.

Here is my example:

Column A-Column B
3.1.1-3.1.1
3.1.2-3.1.2
4.1.1-4.1.1
4.1.2-4.1.3
4.1.3-5.1.1
5.1.1-5.1.2
5.1.2-5.1.4
5.1.3-5.1.5
5.1.4-
5.1.5-


I know it is easy to tell that in Col B, 4.1.2 and 5.1.3 are missing. However, I have 600 rows to look at. So how do I do that using a UDF or a Macro?

Thanks

 

[Aladin Akyurek]

I have two column with almost same data. However, a few IDs are missing in one column.

Here is my example:

Column A-Column B
3.1.1-3.1.1
3.1.2-3.1.2
4.1.1-4.1.1
4.1.2-4.1.3
4.1.3-5.1.1
5.1.1-5.1.2
5.1.2-5.1.4
5.1.3-5.1.5
5.1.4-
5.1.5-


I know it is easy to tell that in Col B, 4.1.2 and 5.1.3 are missing. However, I have 600 rows to look at. So how do I do that using a UDF or a Macro?

Thanks

How about a formula?

C2, control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$2:$A$11,
     SMALL(IF(1-ISNUMBER(MATCH($A$2:$A$11,$B$2:$B$9,0)),
     ROW($A$2:$A$11)-ROW($A$2)+1),ROWS($C$2:C2))),"")

 

[techie2013]

I entered the formula in C2. Not sure I understand how I need to copy down the formula

 

[Aladin Akyurek]

I entered the formula in C2. Not sure I understand how I need to copy down the formula

Try to read on "copying formulas" and "array formulas" in Excel's help.