Thread: Excel Experts
View Single Post
Old 11-15-2007, 04:01 PM  
WiredGuy
Pounding Googlebot
 
Industry Role:
Join Date: Aug 2002
Location: Canada
Posts: 34,497
Quote:
Originally Posted by GrouchyAdmin View Post
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.
I got this done in perl already in 5 lines, but it really needs to be done in Excel since I don't want to import, export and then re-import the data. Especially for a daily routine...
WG
__________________
I play with Google.
WiredGuy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote