+ Reply to Thread
Results 1 to 5 of 5

Count continuous series

  1. #1
    Forum Contributor
    Join Date
    09-10-2010
    Location
    europe
    MS-Off Ver
    Excel 2007
    Posts
    149

    Count continuous series

    How to count the values ​​in the column if the same are in a continuous sequence. Please see attach
    Attached Files Attached Files
    Last edited by Dumy; 08-02-2013 at 05:26 AM. Reason: solved

  2. #2
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Count continuous series

    I did this using helper columns - you can probably combine

    See attached
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    09-10-2010
    Location
    europe
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: Count continuous series

    Quote Originally Posted by mike65535 View Post
    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. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    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
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  5. #5
    Forum Contributor
    Join Date
    09-10-2010
    Location
    europe
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: Count continuous series

    Quote Originally Posted by Ace_XL View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-26-2013, 08:38 PM
  2. Need separate sums of many continuous series
    By J_Grimmer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 09:31 PM
  3. [SOLVED] Excel 2007 : graphing a continuous data series/assuming zeros
    By Taft584 in forum Excel General
    Replies: 5
    Last Post: 04-29-2012, 05:43 PM
  4. Need Help in Numbering a Series..which is both Continous/Non-Continuous..
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2011, 08:27 AM
  5. Continuous series plot
    By dharmik in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-03-2005, 11:05 PM

Bookmarks

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