I am looking for a simple counter that counts every time a cell changes in Column B.
If B10 changes then I would like to have a "1" in G10. If B10 changes again then a "2" is in G10 and so on.
Similarity, if B23 changes then I would like to have a "1" in G23. If B23 then changes again 3 more times then G23 should equal 4.
...and so on for each relevant row down the column.
If the corresponding cell in "I" becomes a "1" then the counter should reset to zero and if there is "" in the same cell then the counter is "ready" to start counting again.
I have included a sample sheet to get going on this.