Ask Your Question

Revision history [back]

Use [AGGREGATE](https://help.libreoffice.org/index.php?title=Calc/AGGREGATE_function) function, which ignores itself if it happens to be in its own range.

Use [AGGREGATE](https://help.libreoffice.org/index.php?title=Calc/AGGREGATE_function)AGGREGATE function, which ignores itself if it happens to be in its own range.

Use AGGREGATE function, which ignores itself if it happens to be in its own range.

So, if you are working with, say, column C, and the range is C2:C10, and C4 is empty, then you may put there this:

=AGGREGATE(1, 0, C2:C10)