Excel count number of groups of consecutive occurrences of same value

Say, for example, I have the following data:

x

o

x

x

o

o

o

x

and I'm interested in x's. The answer in this case would be 3.

For this example, the answer would be 6:

o

x

x

x

x

x

o

o

o

x

o

x

o

x

x

o

o

o

o

x

x

o

x

The values are all in 1 column.

Recent Questions...