https://bugs.documentfoundation.org/show_bug.cgi?id=155424
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |miguelangelrv@libreoffice.o
| |rg
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
You can do it easily with AGGREGATE function, or with LARGE as array.
1 8 =AGGREGATE(14;4;A:A*(A:A<15);2)
2
3 8 {=LARGE(A:A*(A:A<15);2)}
4
5
6
1
3
5
17
21
4
8
12
AGGREGATE help
:https://help.libreoffice.org/7.6/en-US/text/scalc/01/func_aggregate.html?DbPAR=CALC#bm_id126123001625791
LARGE help
https://help.libreoffice.org/7.6/en-US/text/scalc/01/04060183.html?DbPAR=CALC#bm_id3149530
Being possible to get it only with one function, I don't think will be easy to
get it developed.
--
You are receiving this mail because:
You are the assignee for the bug.
