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.
Bookmarks