With current in B and prior in A

=B2-A2

copy down

--

Regards,

Peo Sjoblom


"tucson" wrote in message
...
I'm looking to automate a calculation I do to show changes from a prior
month
to the current month. It's a mix of positive and negative numbers...

ex..
Prior Current **change**
-5 -2 3
-5 -8 -3
-5 2 7