https://bugs.documentfoundation.org/show_bug.cgi?id=100529
--- Comment #4 from m.a.riosv <[email protected]> ---
Created attachment 125848
--> https://bugs.documentfoundation.org/attachment.cgi?id=125848&action=edit
Find_first_v2.ods
Can be done without sort or additional column.
{=MIN(A4:A34*IF(B4:B34<0;1;99))}, needs {Ctrl+Enter] to enter the formula as
array
or
=SUMPRODUCT(MIN(A4:A34*IF(B4:B34<0;1;99))), to avoid enter as array.
or with a simple pivot table as showed in the sample.
But I agree with Joel, not enough for a new function, I haven't seen asking for
it in forums. In fact lately only functions for compatibility reasons have been
added, and it is being a large effort.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
