Showing the increase in the value of a cell

**gally** · 10-26-2012, 07:18 PM

I have data in cell A1 which is linked to an external source and is constantly updating with a new value, is there a formula or macro I can use to show me the increase in value within another cell, here's an example

Cell A1 current value 100 auto updates to 180 after 15 seconds the result I want is the difference between the existing value 100 and the new value 180 i.e. 80 to be shown in another cell, is this possible? I've been looking at it for ages and cannot see how I can do it.

Any help would be greatly appreciated.

Gally

**BeachRock** · 10-26-2012, 08:16 PM

Hi Gally,

Just an idea....

If you can control the update delay on A1, and assuming you aren't trying to keep a running list of historical changes, I was thinking you could have another cell, maybe A2, update itself from A1 but with a 2 second delay after A1 updates. Then have a 3rd cell, A3, just subract A2 from A1. That should (theoretically) give you 13 seconds to read the actual change.

Can you control two separate delays on the same sheet?