Hi,
I'd appreciate any help on how to solve the following issue:
I have a binary set of words (lets say TRUE and FALSE) and want to count the number of consecutive "TRUE" words in a column.
E.g.
TRUE
TRUE
FALSE
TRUE
FALSE
FALSE
FALSE
TRUE
TRUE
TRUE
And the macro or formula should tell me the following in a separate column:
2
1
3
Thanks in advance.
Bookmarks