Calc ignoring hidden rows when appling increment

English
#1

Hi is there a way to apply a simple increment to a column and have the increment ignore hidden rows in the calculation?

#2

The Aggregate function can ignore hidden rows.
For example, enter the formula in cell A1

=AGGREGATE(2;5;$A$1:$A1)

and drag down.
Now try hiding/showing rows.

#3

Thanks sokol. Had a read on aggregate and got it working. Much appreciated :+1:

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.