The setup
A1
S
S
S
D
D
S
S
S
D
D
D
D
A1 is the column I get my values from
B1 would be a helper column that's numeric
B1
1
2
3
4
5
6
7
8
9
10
11
12
I need a formula that will tell me how many times the S REPEATED 3 times REFERENCE TO B1
the average time of the occurrence, and the last time it occurred in reference to b1 (the helper row). Note I have about 8500 values to look in
The answer to the first question should be 2
And last occurrence answer should be 8 via helper row B1: b12
A1
S
S
S
D
D
S
S
S
D
D
D
D
A1 is the column I get my values from
B1 would be a helper column that's numeric
B1
1
2
3
4
5
6
7
8
9
10
11
12
I need a formula that will tell me how many times the S REPEATED 3 times REFERENCE TO B1
the average time of the occurrence, and the last time it occurred in reference to b1 (the helper row). Note I have about 8500 values to look in
The answer to the first question should be 2
And last occurrence answer should be 8 via helper row B1: b12
