Hi Johnny,
Johnny Rosenberg schrieb am 30-Mar-19 um 15:54:
Hi!
Maybe I just don't understand how this works, so I write her for help
determining if this is a bug or not before filing a bug report:
[..]
Now I use the Match function to look using Type=1, ”the index of the last
value that is smaller or equal to the search criterion is returned”. The
formula looks like this:
=MATCH(1;B1:B40;1)
[..]
What am I missing?
see help, "If Type = 1 or if this optional parameter is missing, it is
assumed that the first column of the search array _is sorted_ in
ascending order."
Kind regards
Regina
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
