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