Counting consecutive strings of text

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
 
T

T. Valko

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
 

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

Index/match across multiple columns? 16
Simple nested if and statement 2
Extension of Dependent Pulldown Lists 2
Counting Unique Pairs of Cells 6
Filter with criteria! 1
sum if column is equal to 2 options 3
SUMPRODUCT to calculate unique occurences of string in column of d 3
Counting strings of consecutive numbers in a column 1

Top