Hi,
I joined this forum just to ask this question as I cannot find the answer elsewhere. I have a column of numbers (about 5000), and want to count all of the 0s, but count several in a row as one. I have used the COUNTIF function, however this counts several in a row as several.
For instance, I want "0.4555, 0.6555, 0.7787, 0, 0, 0, 0, 0, 0.5666, 0.76665, 0.4434" to count as only one 0.
To provide a bit of background, it's motion capture data, and I want to count the number of stops, and it captures at 120fps, so a stop normally leads to several 0s in a row, yet this should be counted as one stop.
Thanks in advance for any help,
Beaumy.
Bookmarks