Counting consecutive strings of text
 

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

Counting consecutive strings of text
 

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

--
Biff
Microsoft Excel MVP


"SamG" wrote in message
...
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

Counting consecutive strings of text
 

Check out your previous post

http://www.microsoft.com/communities...6-8d71780c437f

--
Jacob


"SamG" wrote:

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