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