Counting strings of consecutive numbers in a column

S

SamG

Hi I want to be able to count strings of consecutive numbers in the one column.

eg:

Seagrass
Seagrass
Seagrass
Seagrass
NA
NA
NA
Seagrass
Seagrass
Seagrass
NA
...

So i want to count the number of times Seagrass occurs in the one string,
then count how many times it occurs int he next string. eg in the example
above: 4 & 3.

I am at a total loss

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting consecutive strings of text 2
Counting consecutive strings of text 2
Copy addition formula of non-consecutive horizontal cells 2
How to count the numbers in a Word document? 0
counting, multiple conditions and results 1
Counting the number of different entries in a column 2
Excel is not counting 3
Count Consecutive Values 7

Top