Thread: Excel Experts
View Single Post
Old 11-15-2007, 03:58 PM  
GrouchyAdmin
Now choke yourself!
 
GrouchyAdmin's Avatar
 
Industry Role:
Join Date: Apr 2006
Posts: 12,085
There's several ways to do this outside of Excel; UNIX has 'uniq', but doesn't do unique by words, it does it by lines.

I've written a utility to take two sets of lists, and only remove those that contain the first set from the second set.

If you want it to only contain the similar lists between the two, I could easily modify it to do that, and it'll run on Windows with support tools.

Feel free to hit me up on ICQ.
__________________
GrouchyAdmin is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote