Constantly calculate and update the differences in a column of figures

[sherman51]

Hi, (I'm using Excel 2010)

I have a column of figures that are being constantly updated from a source that the spreadsheet is connected to. (In Column C)
In column D I want to display the difference when the figure changes compared to what it was previously, every time that it changes.

ie If C3 is 234.45 then changes to 256.42 then I would want D3 to display 21.97 (the difference), then when that changes to 259.34 I want D3 to then display 2.92 etc ...

The figures in column C may change many times per second

Thanks for any help
Paul

[sintek]

Hi Paul

Play around with this...In sheet Module

Please Login or Register  to view this content.

[sherman51]

Thank you very much, that's excellent ...
Best regards
Paul

[sintek]

.....................................
Thanks.gif