With the starting number in A1 and the monthly number the last entry in
column B then:
=A1-LOOKUP(2,1/B1:B65535,B1:B65535)
will subtract the latest monthly number from the starting number
Note that 65535 is one number short of a full column - the formula will not
work with full columns. If you have any other data in the monthly column
then reduce the 'B' column range to suit.
HTH
Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk
"PghPatti" wrote in message
...
Thanks sdo much for your quick reply but I may not have explained myself
clearly. The second number will be in a different cell each month - at the
bottom of a column. I will want/need to leave the number from the previous
month as it is and enter a new number below that each month. What I will
want
in a cell with the answer is the current difference between the monthly
number and the beginning number. Does that sound clear as mud - LOL!
Thanks for your help!
Pat
|