Results 1 to 7 of 7

Count continuous occurences, restart counting when condition met, exclude conditions met

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2014
    Location
    sweden
    MS-Off Ver
    2010
    Posts
    5

    Count continuous occurences, restart counting when condition met, exclude conditions met

    Hi

    I'm trying to count the number of occurences in A column downwards. See attached *xlsx file with description. Column A only has 3 Values. "A", "B" and "C" in no particular pattern. There will be values inserted every day in A column, so the total number of rows is unknown. But it's ok to copy formula downwards ahead of time.
    The rules are:
    The counting occures in column B (and column C in *.xlsx example file). Values to be counted exists in column A.
    When counting value "A", the counting should restart counting downwards when encountering a value of "C".
    However, if it encounters a value of "B", it should skip it as if uninterrupted, and continue counting "A" until interrupted by a "C".

    So a series of values downwards A column should result in the following in the B column. Please see attached *.xlsx file for example

    Excelforum_count_contious_and_skipped - Copy.xlsx

    A - 1
    A - 2
    B -
    A - 3
    C -
    A - 1
    C -
    A - 1
    B -
    A - 2
    A - 3
    A - 4

    I've tried Countif and IF(S) and searched a lot, but I could only partially solve it. Is it doable in formulas?

    Regards
    Last edited by onni; 01-13-2024 at 06:53 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] count and restart when condition meet
    By pedersenn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2022, 04:37 AM
  2. [SOLVED] Restart count function after meeting condition
    By Jepri in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-18-2017, 03:38 AM
  3. vba code for count restart formula if condition
    By pedersenn in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-18-2017, 02:29 AM
  4. Trying to count occurences if 2 conditions are met
    By Mangesh Yadav in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Trying to count occurences if 2 conditions are met
    By NLithgow in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Trying to count occurences if 2 conditions are met
    By NLithgow in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2005, 11:05 PM
  7. count up the occurences of non continuous value
    By koala in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2005, 06:44 AM

Tags for this Thread

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