Hi,

I feed my Excel file every hour along a row, with one value an hour.
The same formula should be applied only to the latest input. Outputs are displayed in the cell right under the cell containing the corresponding input.
So, basically, what is obtained is a matrix with 3 rows (hours, input and output) and a growing number of columns.

How to remove a formula once an output is computed, to store the output itself and not anymore the formula that allowed to compute this output?
Need a macro? VB? Can I get by with Excel suite of functions only?

Thanks in advance for any insight.

VH