Re: intersection for long list of cells

"Chris " <cag44@xxxxxxxxxxxxxxxxxx> wrote in message
<fu4se9$oh9$1@xxxxxxxxxxxxxxxxxx>...

"Jos " <DELjos@xxxxxxxxxxx> wrote in message
<fu45ub$97b$1@xxxxxxxxxxxxxxxxxx>...
"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

Hi Jos,

Intersect doesn't operate on cells.



(fixed top-posting)

Apparently you mean something else then "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.", since:

A = {'a','b','c'} ;
B = {'a','b','d'} ;
intersect(A,B)
ans =

'a' 'b'

Can you give a small(!!) example of the inputs and the
desired output?

Jos
.

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: intersection for long list of cells
    ... 25K entries long) and I'd like to find the indices of entries that are common between both lists. ... The result is found in positions and this solution should work with stringlists, numeric vectors and 1D cell arrays with both numbers and strings. ...
    (comp.soft-sys.matlab)
  • P words in EDICT
    ... that the other 85,000 entries. ... largly by the presence of those words on study lists, ... 1M hits on Google (with the Japanese language filter set.) ...
    (sci.lang.japan)
  • Re: intersection for long list of cells
    ... entries that are common between both lists. ...
    (comp.soft-sys.matlab)
Loading