[Libreoffice-bugs] [Bug 100529] Suggestion: New function finding the first or last occurrence of a value in a cell area. Like FIND.FIRST (A1:A10; "<4").

https://bugs.documentfoundation.org/show_bug.cgi?id=100529 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED

[Libreoffice-bugs] [Bug 100529] Suggestion: New function finding the first or last occurrence of a value in a cell area. Like FIND.FIRST (A1:A10; "<4").

https://bugs.documentfoundation.org/show_bug.cgi?id=100529 --- Comment #5 from Kolbjørn Stuestøl --- Thank you for your formulas. “In fact lately only functions for compatibility reasons have been added …”. So I have to wait until Excel comes up with a function like this

[Libreoffice-bugs] [Bug 100529] Suggestion: New function finding the first or last occurrence of a value in a cell area. Like FIND.FIRST (A1:A10; "<4").

https://bugs.documentfoundation.org/show_bug.cgi?id=100529 --- Comment #4 from m.a.riosv --- Created attachment 125848 --> https://bugs.documentfoundation.org/attachment.cgi?id=125848=edit Find_first_v2.ods Can be done without sort or additional column.

[Libreoffice-bugs] [Bug 100529] Suggestion: New function finding the first or last occurrence of a value in a cell area. Like FIND.FIRST (A1:A10; "<4").

https://bugs.documentfoundation.org/show_bug.cgi?id=100529 --- Comment #3 from Kolbjørn Stuestøl --- A simple example: Using it for weather statistics to find the first occurrence of frost in autumn. In a spreadsheet A contains the date of the month starting from A1, B

[Libreoffice-bugs] [Bug 100529] Suggestion: New function finding the first or last occurrence of a value in a cell area. Like FIND.FIRST (A1:A10; "<4").

https://bugs.documentfoundation.org/show_bug.cgi?id=100529 Joel Madero changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 100529] Suggestion: New function finding the first or last occurrence of a value in a cell area. Like FIND.FIRST (A1:A10; "<4").

https://bugs.documentfoundation.org/show_bug.cgi?id=100529 m.a.riosv changed: What|Removed |Added CC|