Good evening everybody,

Probably the question has been asked before. My problem is the following,
I'm looking to retrieve the last value in a column. And I have no formula
that is running when the values in the colums are based on a calculation and
if there a cell in this column underneath the last filled cell, that has not
yet returned its value. A clumsy solution is to suppress all the calculations
below the last calculated cell and to reenter the formula in the next cell
when necessary. Has anyone a idea how tio solve this problem?
Here the formula I use for "normal" columns
INDEX(Tab;MAX(LIGNE(Tab)*NON(ESTVIDE(Tab)))-LIGNE(Tab)+1)
in french.
INDEX(Tab;MAX(LINE(Tab)*NOT(ISEMPTY(Tab)))-LINE(Tab)+1) as a translation
with "tab" the name of the zone.

Thank you for any help.

68magnolia71