Results 1 to 8 of 8

Counting Consecutive entries

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    9

    Counting Consecutive entries

    Hi
    I am creating a spreadsheet for health promotion for my clients
    I want to track consecutive days without various habits eg. smoking
    I have a column where the client enters the number of cigarettes smoked and I want another column to show consecutive days without smoking
    I am currently using this formula
    =MAX(FREQUENCY(IF($Z$7:$Z$70="Zero",ROW($Z$7:$Z$70)),IF($Z$7:$Z$70<>"Zero",ROW($Z$7:$Z$70))))

    the problem is that it changes the result in previous rows
    eg. if client smoked on 1st, 2nd, 3rd then didn't smoke on 4th and 5th - when they enter Zero on the 5th it changes the result to "2" on all the rows including 1st, 2nd, 3rd which should say 0

    if someone could help me correct this I would appreciate it
    I am self taught on spreadsheets over the internet so I am definitely an amateur!
    Attached Files Attached Files
    Last edited by AlexAgain; 02-24-2014 at 12:22 AM. Reason: add spreadsheet file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Consecutive Counting - Please Help
    By dmiz002 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2012, 05:28 AM
  2. Counting consecutive 0's
    By bhenderson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2011, 07:25 PM
  3. Formula to recognize consecutive entries
    By Laura2018 in forum Excel General
    Replies: 3
    Last Post: 07-02-2009, 08:24 PM
  4. [SOLVED] Prevent Consecutive Entries
    By JorgeAE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2006, 12:00 PM
  5. [SOLVED] Adding Consecutive Entries
    By FLKULCHAR in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 11:48 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