Combining lists question...

**Barefootsies** · 05-05-2010, 03:25 PM

Hmmm.... I am not sure if there is a simple (automated) way to do that.

**ProG** · 05-05-2010, 03:29 PM

**woj** · 05-05-2010, 03:55 PM

Originally posted by ProG

**alias** · 05-05-2010, 04:04 PM

Definite keeper.

**GrouchyAdmin** · 05-05-2010, 04:21 PM

uniq -i -u file1 file2

**96ukssob** · 05-05-2010, 06:08 PM

Originally posted by ProG

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, 06:11 PM

Originally posted by GrouchyAdmin

uniq -i -u file1 file2

wha?

**96ukssob** · 05-05-2010, 06:28 PM

d'oh, i figured it out... had to swap out a where it spit out the true vs. false value at

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, 06:31 PM

good for a thread save. thanks

**alias** · 05-05-2010, 09:43 PM

Originally posted by bossku69

wha?

Try it in a unix/linux command line.

**LoveSandra** · 05-06-2010, 01:01 AM

Originally posted by mmcfadden

good for a thread save. thanks

Comment