stripping out a list based on a smaller list

stripping out a list based on a smaller list

Post by The Grinc » Tue, 18 Nov 2003 20:54:28



Hi All,

would really appreciate help on this one.

I have a very large list of text strings (50,000) and a small list o
text strings (300). I want to highlight all cells in the large lis
whose contents CONTAINS ANY of the strings in the small list.

any ideas?

CHEER

-----------------------------------------------
~~ Message posted from http://www.yqcomputer.com/
~~View and post usenet messages directly from http://www.yqcomputer.com/
 
 
 

stripping out a list based on a smaller list

Post by Anders » Wed, 19 Nov 2003 00:15:05

One way is to use Conditional Formatting on the long list with a formula like

=SUMPRODUCT(--(B1=$K$1:$K$3))

assuming the long list starts in B1 and the short list starts in K1, adjust the references to suit.

HTH
Anders Silv

 
 
 

stripping out a list based on a smaller list

Post by Dave Peter » Wed, 19 Nov 2003 09:04:30

And Chip Pearson has a bunch of techniques for working with duplicates at:
http://www.yqcomputer.com/



--

Dave Peterson
XXXX@XXXXX.COM