Results 1 to 4 of 4

Restart a Count within a Column

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    nyc
    MS-Off Ver
    2010
    Posts
    2

    Restart a Count within a Column

    count test.xlsxI tried searching for the answer previously, but wasn't having much luck with my syntax, so apologies in advance if I overlooked an existing answer here.

    I have three columns of data: date of observation, level of observation, and a 1 or 0 depending on whether or not the level of observation exceeds a certain threshold. I am struggling to figure out how to do a running count of the number of 1s in the column that resets and restarts whenever a 0 observation occurs. any insights would be greatly appreciated!
    Attached Files Attached Files
    Last edited by cookthebooks80; 07-03-2014 at 12:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Restart Line Count if Value Changes in Seperate Cell
    By jerry.fein in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2013, 03:52 PM
  2. [SOLVED] Restart and increment numbers in column based on changed value in adjacent column
    By Kespin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2013, 06:26 PM
  3. count sessions then restart 365 days after - help
    By itsnotfair in forum Excel General
    Replies: 2
    Last Post: 06-29-2011, 09:31 AM
  4. Count to "X", then restart count at "1"
    By cwkimble in forum Excel General
    Replies: 2
    Last Post: 07-01-2010, 06:47 PM
  5. [SOLVED] 'Do Until...' Restart
    By Jack in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2006, 11:10 AM

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