Excel: Calculating average rate of change in real time

I have a real time numerical value in cell A1. 5 seconds later this value updates into cell A2, then in another 5 seconds it updates into cell A3. This continues in this way up to say cell 200 How can I calculate the average rate of change with respect to all the numerical values in column A at any given time Would really appreciate any help Thanks

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of May 29, 2014.

For more resources for Microsoft Excel