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.
Regards,
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
>
>
--
Atentamente,
Jorge Rodríguez
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
