a1:a20
S
1D
1D
S
S
1D
S
1D
1D
s
S
S
S
S
1D
S
1D
S
1D
1D
1D
s
1D
1D
S
TC
S
S
S
1D
i would like a formula that will count how many times "1d" repeated itself 2x
example
1d
1d
i will have a number in b1 that will represent the number of times i want the formula to lookup the streak to count
b1
3
example
1d
1d
1d
and so on
Bookmarks