Hi there,

I am a totally beginner, so the solution may be obvious but any help you can provide would be greatly appreciated.

I have a number of columns which are a combination of 0's or 1's ('True' or 'Not True' values from a different program)

I would like to check each cell in a column and if it contains a '0' move to the next cell in the column, alternatively if the cell contains a '1' I would like the next cell to be checked to see if it also contains a '1', if there are 10 or more consecutive cells with 1's I would like the sum reported in a separate column. To clarify, each cell represents 10 milliseconds of data and I would like to be able to identify periods of 100ms or more of 'TRUE' data in consecutive cells. Where these periods exist I would like to be able to report the duration of each of these periods in other cells (different columns), I would also like to be able to count the number of periods that fit this criteria in each column (again in a different column). So I would need it to start the process again each time after finding a period that fits the criteria.

I hope this makes sense, and thank you in advance for any insights and help you can provide

Tilly13