+ Reply to Thread
Results 1 to 2 of 2

Maximum count of consecutive non-blank cells in a row

  1. #1
    Registered User
    Join Date
    02-07-2017
    Location
    Baltimore Maryland USA
    MS-Off Ver
    2007
    Posts
    1

    Maximum count of consecutive non-blank cells in a row

    I am preparing a dataset for analysis. It's a calendar of a sort, each cell representing a month over the course of 3 1/2 years. Each row is a subject's record. Using another dataset, I have already determined that each subject with 6 or more contiguous cells populated with data conform to a normal distribution.

    I have an array of cells 42 cells wide and 2993 rows long. Each row is a distinct record. The maximum count of populated cells in any row (of 42) is 18 cells and the minimum count is 1.

    I need to identify each row (of 2993) having a 6 or greater count of CONSECUTIVE, non-blank cells, that count of consecutive non-blank cells, and the first cell in that sequence of non-blank cells (two products.) If a row has more than one series of consecutive non-blank cells, I want the longer or longest of those series on that row.

    I need help trying to accomplish this. Any suggestions?

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Maximum count of consecutive non-blank cells in a row

    Maybe :
    Please Login or Register  to view this content.
    Attached Files Attached Files
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Registered User
    Join Date
    02-07-2017
    Location
    Baltimore Maryland USA
    MS-Off Ver
    2007
    Posts
    1

    Re: Maximum count of consecutive non-blank cells in a row

    Thanks very much Karedog!

    Let me check it out and see what we get...

  4. #4
    Registered User
    Join Date
    02-07-2017
    Location
    Baltimore Maryland USA
    MS-Off Ver
    2007
    Posts
    1

    Re: Maximum count of consecutive non-blank cells in a row

    Thanks very much Karedog!

    Let me check it out and see what we get...

+ 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. Count number of consecutive non blank cells in a column macro excel
    By nasim12w in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2015, 06:00 AM
  2. Replies: 6
    Last Post: 10-29-2014, 05:02 PM
  3. Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  4. Macro to count consecutive blank cells and assign a number
    By voitoosh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-08-2013, 03:24 AM
  5. [SOLVED] count the maximum number consecutive
    By Berna11 in forum Excel General
    Replies: 9
    Last Post: 07-13-2012, 11:27 AM
  6. Count the maximum consecutive TRUEs
    By tomgilb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2011, 12:23 AM
  7. Replies: 2
    Last Post: 09-01-2010, 07:48 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