Hello Aladin,

Thank you for the formulas. I will put them in place and be back to you.
Also thanks for the translation. Not always easy and hard to find someone
with a english version of Excel. It's everything but plain english.

68magnolia71

"Aladin Akyurek" wrote:

68magnolia71 wrote:
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

The following would return the last numeric value:

=LOOKUP(9.99999999999999E+307,A:A)

=RECHERCHE(9,99999999999999E+307;A:A)