Counting consecutive strings of text

  • Thread starter Thread starter SamG
  • Start date Start date
S

SamG

Hi

I want to be able to count how many consecutive numbers are in a column but
once there is a break to count the next string in the same column. eg:

A
Apples
Apples
Apples
Apples
Apples
NA
NA
Apples
Apples
Apples
NA
.....

So the output that i want is to count the string of Apples (ie: 5) skip the
NA then give me a second output of 3.

Is this possible? Thanks
 
You need to be more specific...

Do you want something like this:

Apples
Apples
Apples
Apples
Apples....5
NA
NA
Apples
Apples
Apples...3
NA
 
Back
Top