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.
To unsubscribe e-mail to: email@example.com
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
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