Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi,

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:-

=MAX(IF(A2:A13=D1,B2:B13))

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

=MAX(IF(A1:A9=D1,B1:B9,))

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.

Thanks

Mick