+ Reply to Thread
Results 1 to 2 of 2

Count Consecutive Columns Between Two Values

  1. #1
    Registered User
    Join Date
    07-01-2021
    Location
    CA
    MS-Off Ver
    16.48
    Posts
    1

    Count Consecutive Columns Between Two Values

    Hi guys!

    I'm working on an excel formula that counts the number of consecutive months with values between 1 and 5.


    I've created a few other formulas successfully with different criteria but i'm tied up with the range portion.

    - Consecutive Months with values equal to 1
    - MAX(FREQUENCY(IF(C2:N2=1, COLUMN(C2:N2)), IF(C2:N2<>1, COLUMN(C2:N2))))

    - Consecutive Months with values greater than 5
    - MAX(FREQUENCY(IF(C2:N2>=5, COLUMN(C2:N2)), IF(C2:N2<5, COLUMN(C2:N2))))

    Does anyone have any recommendations or tips in accomplishing this?

    Thanks for your help!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,087

    Re: Count Consecutive Columns Between Two Values

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn



+ 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. [SOLVED] Formula to count consecutive non-zero values and reset count after a non-zero value
    By jchriste11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2021, 12:08 PM
  2. Replies: 2
    Last Post: 07-30-2018, 02:21 PM
  3. Count consecutive letters in columns
    By Gitanos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2018, 01:12 PM
  4. Count of Values (Rows) of Most Recent Consecutive Streak (2+ Distinct Values)
    By ExcelForum88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2016, 12:26 PM
  5. [SOLVED] How to count consecutive columns
    By adrianplunkett in forum Excel General
    Replies: 13
    Last Post: 05-21-2012, 10:02 AM
  6. [SOLVED] Count non consecutive columns
    By mkondo@uk.ey.com in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2006, 10:30 AM
  7. Count Intervals of 2 Consecutive Values in same Row and Return Count across Row
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-29-2005, 11:30 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