View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Espen Rostad[_2_] Espen Rostad[_2_] is offline
external usenet poster
 
Posts: 25
Default Calculate difference between cells with possible gap

I have a WS monitoring use of water on a daily basis. In column A i have the
dates for a whole year, in column B I put in the amount of liters passed the
measuring device and in column C i have a formula that gives the amount of
water used since last reading. (Simply latest value - previous value)

My problem occurs when there comes a day when the counter has not been
checked and there is no input value. I Want to ceep all dates in Column A

How can I solve this?