Forum Discussion
Solved
Daily average,skipping cells
I’m attempting to make a formula that can use in our pump stations. The formula as currently written functions properly when I am at the station DAILY (The meters are gallons, and “/42” is added to co...
Hi,
that could be like
=IF(B3<>"", (B3-LOOKUP(2,1/($B$2:B2<>""),$B$2:B2))/42 /(A3-LOOKUP(2,1/($B$2:B2<>""),$A$2:A2)), "")
if put the formula in B3 and drag it down. LOOKUP finds the value of the previous non-empty cell in the column B (first LOOKUP) and value of the related cell in A (second LOOKUP)
Please see attached
Hi,
that could be like
=IF(B3<>"", (B3-LOOKUP(2,1/($B$2:B2<>""),$B$2:B2))/42 /(A3-LOOKUP(2,1/($B$2:B2<>""),$A$2:A2)), "")
if put the formula in B3 and drag it down. LOOKUP finds the value of the previous non-empty cell in the column B (first LOOKUP) and value of the related cell in A (second LOOKUP)
Please see attached