Hi there,

I have two columns in Excel: column A and column B.

Column A has items: car, cat, rat, mat, box
Column B has items: box, truck, cat, car, desk

How do I remove duplicate items from column B? In my case I want the words "cat" and "car" removed from column B.

Of course, my real columns have thousands of items in them, so I can't do it by hand.

Excel gurus, help me please!

Thank you!