At 08:52 16/11/2015 -0600, Jorge Rodríguez wrote:
I understand now what you are saying
I don't think you do - at least, not entirely.
You haven't clarified the answers to various
questions. I don't need the answers to these - but you do!
- I need to find which games of the first Matrix
appear in the second Matrix finding equal string
or equal word into the string. For example:
Column-Row A1 Column-Row A6
0 A.D. 0 A.D. Empires Ascendant
The content of A1 and the content of the A6 are
about the same game but they uses different name
(One single and the other complete) I need to
find A1 for A6 in Column B6 of Second Matrix by
the key in this case "0 A.D." that appear in
both names. Sometimes, both, the name of the
game of the First Matrix and the name of the
second Matrix are equals. I try to do this by
formula unknowing the exactly key but knowing that there is.
You do not know what exactly the key is, but you
are expecting a formula in Calc to guess this for
you. Surely that is worse than expecting it to
read your mind, since even your mind does not know the answer, you say?
Before you can do anything like this, you do need
to have a clear statement of exactly what
constitutes a match and what doesn't. If you had
"Whatever" in one column and "Whatever 2" in the
other, would these be the same game or would one
be the successor to the other? If one column
included "0 A.D." and the other "0 A. D.", would
those be the same? What about "0 A.D." and "0
AD"? You probably cannot rely on names assembled
from different sources being entered identically.
It may well be, of course, that it will be more
or less impossible to define exactly what
constitutes a match. In that case - and
especially if the lists are not particularly
large and you are doing this process once, not
regularly - you may find that manual inspection
is your quickest route. You could start by
looking for exact matches (as explained
previously). How about then sorting the lists
alphabetically and picking out obvious matches?
You could then transfer these items or rows into
a new list. This would bring any further matches
closer together and enable you to identify more.
Even if you could come up with a clear criterion
for a match, you would inevitably have to do a
lot of manual checking afterwards to eliminate
false positives and to add missed matches.
I trust this helps.
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy