https://bugs.documentfoundation.org/show_bug.cgi?id=100529
Bug ID: 100529
Summary: Suggestion: New function finding the first or last
occurrence of a value in a cell area. Like
FIND.FIRST(A1:A10;"<4").
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kolbjo...@stuestoel.no
I would like to have a function who finds the first or last occurrence of an
item in a cell area.
Something like
FIND.FIRST(B1:C20,A1) and FIND.LAST(B1:C20,A1)
where A1 contains the needle (what should be found), C1:C20 the search area
(the heystack) and if found in C1:C20 returns the value of the corresponding
row from B1:B20.
Also FIND.FIRST(B1:B20,A1) where the returned value is the address to the
actual cell in B1:B20 will do.
A1 could contain a number value or something like "<5" to find the first
occurrence of a number less than 5. Including text would be top.
What could this function be used for?
If I for example are running a store opening at 7 in the morning with a few
employers. (I assume the cash register is connected to Calc). What time of the
day is the first sale? If I never sell anything before 10 o'clock, I could save
some wages, and consider sleeping 3 hours more in the morning.:-)
Or I could find out what day was the first rainy day in June or the first
frosty day in the autumn the latest 20 years, or when my wildlife cameras first
recognized an elk, and many others like these.
I have not found this function in other spreadsheets, so perhaps Calc will be
the first one?
I am now using a walk around, so I am not asking for how to do this
calculations. I am only asking for a function to do this in a simpler way.
Kolbjørn Stuestøl
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs