Issue 117463

Summary: Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)
Product: Calc Reporter: wallace.maxted
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P2 CC: elish, issues
Version: 4.1.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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.