Discrete functions: max and min relatives

Hello Mika,

Change $A$22 to $A$65536.

Normally the min/max should change if and only if the underlying data
changes or is added.

The -1E308 and 1E308 are very low (negative) and very high (positive)
numbers which are given to the formula when we face the list boundaries
(lower or upper end). We do not want to get #REF! errors but we do not
want to introduce any value which alters the min/max comparison,
either. So these values are fed as "innocent" comparison values (1E308
will not hurt any min calculation, -1E308 any max calc).

If you still have problems, post or email an instructive example,
please.

Have fun,
Bernd

Thanks Bernd,

it is working !, my mistake was that I had replaced A22 for the end of
the variable interval I was checking, not the inferior limit of that
data.


Mika

Hi Bernd,

Still have some problems when adding new date and using the formula. To
show it better, I sent you an excel file showing it.

Rg
Mika