"Subtracting" text in column B from column A

Having a heck of a time figuring this one out, and it seems so simple.

I have data in column B that I would like to 'subtract' from column A. For example....

Column A:
Apple
Banana
Carrot
Durian
Eggplant


Column B:
Apple
Durian
Eggplant

....the result would be:

Column C:
Banana
Carrot


Instead of 'subtracting,' it could be seen as finding duplicates and deleting both copies, too. Do I need to use a formula of some kind? A filter? Either way, I've tried and I'm just confused! Any explanation would be appreciated (and layman's terms too, please). Thank you!

One thing you can do (maybe not the "best" solution) is to put the following in Column C and then filter out the blanks.

Please Login or Register  to view this content.

Nice solution Martin!

I either do not know how to properly insert these formulas, and/or they do not work for me.

Instructions, anyone...? I usually stay away from Excel formulas whenever possible, so I am a total novice.

For reference, Column A is 501 rows, and Column B is 295 rows. (Once again, I need to subtract B from A and have the new list populate in Column C. Cells contain both text and numerical data.)

Thanks-!

Copy cells C1 and D1 down to row 501.

Great! Looks like I got it.

...but what is the meaning of Column D? I realize the numbers listed are the same as their row number, but not all of the rows have a number listed. Just curious.

If column D is blank, it means that the item in column A is duplicated somewhere in column B. If column D contains a number, yes, that's the row identifying the item in column A that's NOT duplicated. Column C then uses column D to identify which items from column A to put on your short list.