Counting batches of data

[UkGazzr]

Hi all,

I have a table of data, one of the columns contains data about whether a machine was running or not (A) in my example below. Each row is a one minute snapshot and the cell will contain either a 0 or 1 for not running / running. I can sum the column (A) and find out the total minutes that the machine was "On". But i would like to know the number of occasions that it became "On". I am hoping to achieve this via a formula in an adjacent column (B). Column B should only contain a "1" for the first row where column A becomes a "1". After much googling I've not found a solution that will work within a table.

A,B
0,0
1,1
1,0
1,0
0,0
0,0
1,1
0,0
0,0
1,1
1,0
1,0


Any suggestion / solutions would be appreciated.

[CK76]

If you are going to do it in B... assuming that data starts at A2

Please Login or Register  to view this content.

[UkGazzr]

Your solution references A1, which would be my tables column header. I'm not sure this will work for me.

Edit****
Ignore me - I tried it and it works fine. Thanks...!!