GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Combining lists question... (https://gfy.com/showthread.php?t=967030)

96ukssob 05-05-2010 04:20 PM
Combining lists question...
 
I have two lists of terms... one has 500 and the other has 350. Anyone know a way (Excel preferred) to easily find what terms of the 500 are NOT in the list of 350?

Barefootsies 05-05-2010 04:25 PM
Hmmm.... I am not sure if there is a simple (automated) way to do that.

ProG 05-05-2010 04:29 PM
http://www.lmgtfy.com/?q=use+excel+t...+lists+of+data

woj 05-05-2010 04:55 PM
Quote:
Originally Posted by ProG (Post 17111248)
:1orglaugh:1orglaugh

alias 05-05-2010 05:04 PM
Definite keeper.

GrouchyAdmin 05-05-2010 05:21 PM
uniq -i -u file1 file2

96ukssob 05-05-2010 07:08 PM
Quote:
Originally Posted by ProG (Post 17111248)
:1orglaugh:1orglaugh i tried that but no luck. I can find out how to do it with numbers, but with words it wont work :(

96ukssob 05-05-2010 07:11 PM
Quote:
Originally Posted by GrouchyAdmin (Post 17111360)
uniq -i -u file1 file2
wha? :helpme

96ukssob 05-05-2010 07:28 PM
d'oh, i figured it out... had to swap out a where it spit out the true vs. false value at :winkwink:

incase anyone wanted to know...
Code:
=IF(ISERROR(MATCH(A1,$C$1:$C$362,0)),A1," ")
*where column A = long list and column C = shortened list... hence finding terms in column A that are not in C

mmcfadden 05-05-2010 07:31 PM
good for a thread save. thanks

alias 05-05-2010 10:43 PM
Quote:
Originally Posted by bossku69 (Post 17111657)
wha? :helpme
Try it in a unix/linux command line.

LoveSandra 05-06-2010 02:01 AM
Quote:
Originally Posted by mmcfadden (Post 17111691)
good for a thread save. thanks
:1orglaugh:1orglaugh:1orglaugh:1orglaugh:1orglaugh


All times are GMT -7. The time now is 12:54 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123