Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description wallace.maxted 2011-03-18 21:46:36 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
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:32:23 UTC
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
Comment 2 Edwin Sharp 2013-11-18 20:00:29 UTC
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.