Hi,
This is also not dynamic.
I meant to say whether I can give circular references in excel
sheet so that the cells in itself will take higher value than original.
--
Hemant N. Dhuri
Mumbai


"AlfD" wrote:

Hi!

If you duplicate the cell A1 elsewhere (=A1), you can check (data
validation using Number) with min set as the stored value and max set
as something arbitrarily big.
The stored value will update itself, ratchetting upwards only.

Alf