Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


I did some digging prompted by JohnSUN and pierre-yves's answers and found this formula on an Excel forum when looking for the MAXIFS() function:-


Based on that, Libre Calc was happy when I entered this:-


and executed it as an array formula by pressing Ctrl-Shift-Enter.

Not sure if this is the best way, but it got me what I want. I'm a happy boy now.