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!
Bookmarks