Do you have an example of the data you can upload?
Hey guys
I basicly have a column of 1s and 0s(on and off), and i need to know the total number of times the machine starts, including the first time.
The machine starts every time the data switches from a 0(or group of 0s) to a 1.
How would i go about writing an equation(probly containing the IF command) to count these iterations?
Cheers.
alright sorry I didn't realize you only wanted switching from 0 to 1,
So let's say your list starts in the cell A1,
use this function is a cell =IF(AND(A1=0,A2=1),1,0) and drag it down
Then at the bottom of the collum, make one cell equal to the sum of the column =Sum(A1:A_n) and then add 1 to that number if your number in A1 is a 1, don't add 1 if it's a 0 in A1