2015 Archives by date, by thread · List index

# 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

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