Remembering and using previous values

Please refer to the attachment.

This is a sequence of values over a time period. Ignore the figures in the centre columns.
As you can see, the figures either side of the columns vary over time. For example, the change on the previous in the top right figure in red is –5. Values can also increase – first figure in left column has gone from 82 t0 184 (+182).

Is it possible to determine a change in a cell’s value from its previous value (and inserted to the next column – left/right)? Presumably this would entail “remembering” or temporarily retaining - I have seen this directly in Excel but can’t remember the details.

I have include part of the code below if it helps.

There is a related, but separate, question which I will post in due course.

Any suggestions greatly appreciated.

Grant.

Please Login or Register  to view this content.