intersection for long list of cells

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!
.

Relevant Pages

  • Re: import contacts from excel
    ... The behavior you describe indicates that the named range doesn't match the cells you want to import. ... It lists ... > it through, it makes 65,000 new BLANK entries in my contacts. ...
    (microsoft.public.outlook)
  • Re: How to sort/update large excel db
    ... column with all unique entries. ... cells someplace. ... On 2 of the earlier database versions, ...
    (microsoft.public.excel.misc)
  • 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)
Loading