Re: [libreoffice-users] Match Items from two different matrix

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: users+unsubscribe@global.libreoffice.org
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