Seeking a Shorter Fuzzy Search Formula

[the.yangist]

I'm looking for an easier formula that will allow fuzzy searches for different elements in an array in an array. I use Calc, but there aren't too many troubles with crossovers.

I'm looking for a shorter or faster formula that will match this one:

=1*not(iserror(search(Xx,Yx:Yy)+1*not(iserror(search(Xy,Yx:Yy)+...

It's a part of some work that I'm doing in lexicography and morphology, if you're curious about why I would need such a formula...

It aims to answer this question: Can you find this string, or this string, ... or this string inside this array, and if so, which ones have more of those said strings than others?

 

[pgc01]

Hi
Welcome to the board

Can you post a working example with inputs, logic and expected outputs?

 

[the.yangist]

Yes. I have added a snippet of my work here: http://dl.dropbox.com/u/12391264/Lexicography%20Example%20Snippet.ods. I can't see how to attach it into the OP or in a reply.

I'm looking for a shorter formula under the MATCHES? heading (column K).

 

[pgc01]

Hi

Since you are new to the board let me tell you that using external links to data is not a good idea:

- many of the board members will not download external files

- it makes this thread useless in the future. If anyone has a problem similar to this one some months from now and finds this thread, the link will be dead so this thread won't help anyone.

Options:

1 - You can post the data simply in text mode

2 - select a table in the worksheet, add borders, copy and paste it in your post

3 - use a html maker to post a table. This may be the most usual solution.

To post a HTML table you can use, for ex., the board's version of the HTML maker, http://www.mrexcel.com/forum/showthread.php?t=399380 or Excel Jeanie, http://www.excel-jeanie-html.de/index.php?f=1