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