D
Demosthenes
Hi,
I'm trying to write a formula that will go down a column and count the
number of one value cells that occur between those of another value. For
example, given:
P
S
S
P
S
S
S
S
P
P
S
P
in column A, I'd like a formula in column B that gives:
P
S
S
P 2
S
S
S
S
P 4
P 0
S
P 1
I want the columns opposite the "S" to remain empty. I've been playing with
the =FREQUENCY function, but haven't been able to figure it out.
Thanks,
I'm trying to write a formula that will go down a column and count the
number of one value cells that occur between those of another value. For
example, given:
P
S
S
P
S
S
S
S
P
P
S
P
in column A, I'd like a formula in column B that gives:
P
S
S
P 2
S
S
S
S
P 4
P 0
S
P 1
I want the columns opposite the "S" to remain empty. I've been playing with
the =FREQUENCY function, but haven't been able to figure it out.
Thanks,