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

Hi Brian:

        I understand now what you are saying

        Following my last e-mail:

- In the first Matrix (Sheet 1), I have a list of games from a site of
internet (Column A)

- In the second Matrix (Sheet 2), I have my own list of games.

- Neither name is repeated into first Matrix or into second Matrix

- 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:

First Matrix:                   Second Matrix:

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.

Thank you again,


Jorge Rodríguez

El lun, 16-11-2015 a las 08:17 +0000, Brian Barker escribió:
At 09:01 15/11/2015 -0600, Jorge Rodríguez wrote:
I try to do better:

Oh, I didn't mean to criticise, just to explain 
that any problem needs to be defined before it can be solved.

a) Both matrix have column A (The first Matrix 
is in Sheet 1 and the second Matrix is in Sheet 2)
b) I want to compare the content of A1 of the 
first Matrix with all the column A of the Matrix 
2 searching an equal or similar content string 
there. The content in all rows of the column A 
of the Matrix first is different between them. In second Matrix too.
c) I need continue to do this with A2...An of 
the first Matrix with all the column A of the Matrix 2

Actually, most of that was clear previously. 
Since you are now comparing cells from different sheets, instead of
you need something like
- filled down a column, of course.

But as soon as you use a word such as "similar", 
that needs defining accurately before you can 
construct the formulae you need. LibreOffice will 
not read your mind. Are "My dog's name is Fido" 
and "My dog's name is Rover" similar? Are "My 
dog's name is Rover" and "I often buy rover 
tickets" similar? Are "My dog's name is Rover" 
and "Today is Monday" similar? (They both contain 
"is".) Are "16th November" and "November 16th" 
similar? Are "The cat sat on the mat" and "The 
cat sat on the mat." similar? How about "Jorge 
Rodríguez" and "Jorge Rodriguez"? Or "John Smith" and "John  Smith"?

You also haven't clarified what sort of result 
you need: is a simple column indicating whether 
each row satisfies your similarity criterion (as produced above) what you need?

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.