compare 2 columns and remove rows that match

[ibf]

I'm not sure how to do this or if it can be done. I have 2 columns of of numbers. I want to remove numbers in column A if the number is in column B. I've tried to look it up on how to do but can't find anything.
Can some one help??

Column A Column B
3551001 3551002
3551002 3551004
3551003
3551004
3551005

I would like result to look like this:

Column A Column B
3551001 3551002
3551003 3551004
3551005

 

[smiths87]

You could put the following formula in Column C (or wherever). Select cells C1 through the lenth of your data in Column A, hit F2, enter this =if(iserror(match($A$1:$A$5, $B1:$B2, 0)), $A$1:$A5, ""), and confirm it with Shift+Control+Enter. That will give you everything in Column A that isn't in Column B.

 

[ibf]

thanks for your help that worked
ibf