Thread
:
Meter Readings
View Single Post
#
6
Posted to microsoft.public.excel.newusers
Sandy Mann
Posts: n/a
Meter Readings
"daddylonglegs"
wrote in message
news:daddylonglegs.2691am_1145009404.7613@excelfor um-nospam.com...
=MOD(D2-C2,100000)
I like that one daddylonglegs
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"daddylonglegs"
wrote in message
news:daddylonglegs.2691am_1145009404.7613@excelfor um-nospam.com...
If you have this months meter reading in D2 and last months in C2 then
this formula will give the units used
=MOD(D2-C2,100000)
If you set up your spreadsheet with each meter on a separate row,then
you can have a meter identifier in column A and first date's readings
in column C, second date in D etc. (row 1 contains meter reading date).
In B2 copied down you could use this formula
=MOD(LOOKUP(100000,C2:IV2)-LOOKUP(100000,C2:IV2,B2:IU2),100000)
which will automatically give you the units used for the last month
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=532820
Reply With Quote