Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Hi Brian:

        Thank you for your support, I just order both matrix alphabetically and
I tried to use VlookUp but it gave me a several false-positive as you
toll me. But at this moment is my only way if not I would had to have it
complete manual.


Jorge Rodríguez

El mié, 18-11-2015 a las 09:27 +0000, Brian Barker escribió:
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.

Brian Barker


Jorge Rodríguez

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.