Apache OpenOffice (AOO) Bugzilla – Issue 117463
Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)
Last modified: 2013-11-18 20:00:29 UTC
I want to find the last occurrence of a string in a sheet, but it seems there is no way to do this? =MATCH(".*TEXT.*", RANGE, 0) finds the first occurrence =MATCH(".*TEXT.*", RANGE, 0, -1) could find the last occurrence and perhaps =MATCH(".*TEXT.*", RANGE, 0, n) could find the nth occurrence
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
According help: "If a higher value is found during the search in the column, the number of the previous row is returned." In reality MATCH returns row number of last occurrence. The enhancement given in description is useful.