Hi Jon,
If your source data is one row for each reading like: date, reading #1
(or #2 or...), water volume value, read it into Excel so it maintains
that 3 column format with one row for each reading.
Then try using a pivot table to set the dates across the top on
columns, and the reading numbers down the side on rows and the water
volumn value as the data.
Then add a row below the table where you subtract the first reading row
from the last reading row.
I'm not sure how to automate this without using VBA, but perhaps this
is close enough?
ExcelGirl
--
ExcelGirl
------------------------------------------------------------------------
ExcelGirl's Profile:
http://www.excelforum.com/member.php...o&userid=25272
View this thread:
http://www.excelforum.com/showthread...hreadid=387635