Comparing 2 text columns and extracting their differences to a third
Posted by Chris Woodward on July 14, 2000 7:50 PM
Hi all, nice to discover this site, as I have a question that has befuddled me for some time. Mind you, I'm a bit of an Excel amateur - I imagine there is a very simple equation for this, but I've had no luck in finding it.
I have 2 text columns, and they're both rather long. The columns share many of the exact same words (punctuation & all), but there are some words that are particular to a single column. I want to know what those words are (the differences) w/o having to manually sort through the two columns. Is there something that will allow me to compare these 2 columns and then insert copies of the "uncommon" words from one column or the other into a seperate space?
Thanks for any help,