Ask Your Question

How do I perform further queries on a filtered range excluding hidden cells

asked 2015-06-23 11:42:51 +0100

answer-B gravatar image

If I create a chart from a range of cells in Libre Calc, and then apply a filter to the range, the chart automatically updates with those cell ranges that has not been hidden by the filter.

However, I am trying to achieve this using ( Maxa() ) or something simular, which does not produce the results I am looking for.

Maxa() still takes into account the cells that are hidden due to applied filter.

So how am I able to filter a multiple column range, then find out what cell in a particular row has the maximum value ?.

Thanks in advance

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-23 14:30:52 +0100

pierre-yves samyn gravatar image


=SUBTOTAL(4; A2:A20)

Gives the maximum value of the range A2:A20 taking into account filters (adapt ; according to Tools Options Calc Formula Separators Function


edit flag offensive delete link more


Perfect !

Thank you so much, pierre-yves samyn.

answer-B gravatar imageanswer-B ( 2015-06-25 14:40:14 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-23 11:42:51 +0100

Seen: 39 times

Last updated: Jun 23 '15