count the number of zero values between non-zero values along a single column

Hi,

I have a column of hourly weight measurements in B which looks like this:0.0075, 0.005, 0.01, 0.015, 0.0075, 0.005, 0.005, 0.0025, 0, 0, 0.0025, 0, 0, 0, 0, 0.0025, 0, 0, 0, 0, 0.0025.I would like to be able to count the span*of zero values between non-zero values in column C, for example 2, 4, 4 . Doing it manually is tedious for a large dataset. The test data is attached. Thanks!

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hello FlameRetired, this formula worked flawlessly. I can't thank you enough for assisting me in resolving the issue. Your assistance has made a significant difference.

Greg, thank you for your assistance! I appreciate it

Hi again,

You're welcome - hope you found my suggestion interesting if not useful.

Regards,

Greg M

Hi again,

Many thanks for the Reputation increase - much appreciated!

Best regards,

Greg M