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!


--
username123
------------------------------------------------------------------------
username123's Profile: http://www.excelforum.com/member.php...o&userid=35863
View this thread: http://www.excelforum.com/showthread...hreadid=556564