"Sandy Mann" wrote in message
...
I had noticed *empty* posts like the one above before and wondered why. I
posted a reply this morning at work through Google and all that has shown
up is Pete's original post. I must have done something wrong I suppose.

Anyway what I posted was:

"Pete_UK" wrote in message
oups.com...

adding back in 10 raised to the power (number of dials). The formula
from Sandy seems to be getting very complex.

It's would not be so bad if it was just complex but it is wrong to boot!

What I should have posted was:

=MOD(LOOKUP(10^LEN(C2),D2:IV2)-LOOKUP(10^LEN(C2),D2:IV2,C2:IV2),10^LEN(C2))*B2+(( LOOKUP(10^LEN(C2),C2:IV2,C1:IV1)"")*10^LEN(C2))

But I would think that if there was any chance of the meter turning over
more than its capacity then Maria should be looking at replacing the meter
with one of greater capacity.

I couldn't get this one to work Sandy - sorry !

It just gives me a zero for an answer each time.

The meters never go round more than once, quite often not going all the way
round for many many months

Thanks again.

Tracey