Re: intersection for long list of cells



"Chris " <cag44@xxxxxxxxxxxxxxxxxx> wrote in message <fu42p1
$o5k$1@xxxxxxxxxxxxxxxxxx>...
Hi all, I have two long lists of strings in cells (each
25K entries long) and I'd like to find the indices of
entries that are common between both lists.

I'm hoping to find a faster way of doing this than an
individual search (which takes way to long given the size
of the lists)

Thanks!

help intersect

Jos
.



Relevant Pages

  • Re: The Anime Primer "Pre-Approved List"
    ... but aren't yet in the Primer. ... only write entries for shows you like enough to recommend to ... quarterly anime review lists, three stars on Manbow Papa's quarterly ... Ouran High School Host Club ...
    (rec.arts.anime.fandom)
  • Re: Synchronization routine
    ... Basically I have two lists, one on my firewall and one in a database. ... current sizes are over 1 million entries and I expect to see 2 million rows ... which I can randomly access ... quicksort wasn't too efficient and finally caused a stack overflow. ...
    (comp.programming)
  • Re: Best writers I havent yet read
    ... Science Fiction> and. ... considered was to look for authors represented by multiple books in my ... So I've spent much of this past week compiling a list of author entries ... If anyone wants the full lists, or whatever, well, e-mail or post, ...
    (rec.arts.sf.written)
  • [info] The Anime Primer "Pre-Approved List"
    ... but aren't yet in the Primer. ... only write entries for shows you like enough to recommend to ... quarterly anime review lists, three stars on Manbow Papa's quarterly ... Tokyo Mew Mew / Mew Mew Power ...
    (rec.arts.anime.misc)
  • Re: OL2002: Adding list of contacts to a Distribution List after search
    ... My Contacts entries have multiple Categories, so let's say I want to ... or simply Friends New York. ... Categories - once in Friends, again in Business, and a 3rd time in New ... |> I need to create email distribution lists of people that meet ...
    (microsoft.public.outlook.contacts)

Loading