Hi Roger,

the appearance of consecutive numbers of the same value in column C
doesn´t mean that it is a failure of the pump to give a true reading. Those
are REAL values. The failure occurs in the formula (it freaks out :)).

"Roger Govier" escreveu:

Hi Vincent

If the appearance of consecutive numbers of the same value in column C
always mean that it is a failure of the pump to give a true reading, then
you could use a formula in column D

=IF(C7="","",IF(C7=LOOKUP(9,99999999999999E+307,$C $6:C6),"",C7))
and copy down.
Carry out your Average function using column D instead of column C.
--
Regards
Roger Govier