https://bugs.documentfoundation.org/show_bug.cgi?id=155424
Bug ID: 155424
Summary: LISTIF function
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: liammcgillivra...@gmail.com
Description:
I propose a new function called "LISTIF" for Libreoffice Calc. This function
finds the nth value in a range that meets the stated criterion.
It would have the following arguments:
Range: The range to be evaluated by the criteria given.
Criteria: The criterion to be applied to the range.
Number: The nth value that meets the criterion will be displayed.
List range (optional): The range from which outputs will be drawn.
If the "number" argument is set to "1", then this function will output the
first value in the range that meets the criteria. If set to "2", it will output
the second.
Actual Results:
Expected Results:
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug.
