# Count continuous series

1. ## Count continuous series

How to count the values ​​in the column if the same are in a continuous sequence. Please see attach

2. ## Re: Count continuous series

I did this using helper columns - you can probably combine

See attached

3. ## Re: Count continuous series

Originally Posted by mike65535
I did this using helper columns - you can probably combine
Thank you Mike for the appearance
The idea is good.
I'm trying to find a formula without extra help columns (if there is a possibility)
regards

4. ## Re: Count continuous series

In B2

=IF(OR(A3="",ABS(A2-A3)>MAX(ABS(A2),ABS(A3))),COUNTBLANK(B\$1:B1)-SUM(B\$1:B1)+1+COUNT(B\$1:B1),"")

Copy down

5. ## Re: Count continuous series

Originally Posted by Ace_XL
In B2
Ace thank you for answering.
The idea is OK, but then the problem with zero (0).
If a cell in column A contains the value zero then there is no break between series
Is there a possibility that the formula ignores the zero (0) and return an empty cell in the same row

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1