I have data in rows which contain IF statements that result in a 1 for true or 0 for false. I need to count the number of consecutive 1 values until a 0 is hit. For example:
A B C D E F G
1 1 1 0 1 0 3
1 1 0 0 0 0 2
1 0 1 1 1 1 1
0 1 0 0 1 1 0
My result is in column G.
Any suggestions?
Thank you!!
Bookmarks