This may sound like an easy question but it has been
puzzling me for days!!
Any Help on this would be great

3 meter numbers, All different readings taken on
different dates. On each visit all 3 are read. I would
like to be able to have a pivot table where the
difference between the readings taken is shown. Based on
chronological order following the date read column to
sort by.

My data will look like this -

Column A Column B Column C Column D
Little Richard SP C61L 00578 15/12/2004 63587
Little Richard SP C66L 12364 15/12/2004 63033
Little Richard SP C66L 09812 15/12/2004 95529
Little Richard SP C61L 00578 15/01/2004 63597
Little Richard SP C66L 12364 15/01/2004 63061
Little Richard SP C66L 09812 15/01/2004 95568
Little Richard SP C61L 00578 15/02/2004 63647
Little Richard SP C66L 12364 15/02/2004 63172
Little Richard SP C66L 09812 15/02/2004 95754

I need the output of days difference between readings on
each meter. And a total difference between the current
and last reading for the corresponding meter number.

So for the above I would like to show 31 days for the
difference on all meter numbers and then for each meter
number a difference of

C61L 00578 - 10
C66L 12364 - 28
C66L 09812 - 39

C61L 00578 - 50
Etc..

Then to calculate the amount used per day for each meter
number

Peter