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
Count Consecutive Values 7
Excel Count of Consecutive Data 0
Counting the number of different entries in a column 2
How do I count # of cells with same value other column? 4
COUNTIF formula multiple text exclusions 4
Counting Consecutive Cells that meet Criteria 2

Top