Results 1 to 7 of 7

I need to count consecutive values in a row that is interspersed with blank cells

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    France
    MS-Off Ver
    Mac Excel 2011
    Posts
    4

    I need to count consecutive values in a row that is interspersed with blank cells

    Greetings Everyone!

    This is my first time; please be gentle. Does anyone know how I can count (within a row) the largest number of consecutive cells that are not blank? For instance, among multiple rows of data, row 1 has 10 consecutive cells that aren't blank, row 2 has 15, row 3 has 12, etc. I have hundreds of rows and the blanks are never in the same place. "Count" is returning the total number of cells that have values, but not the maximum number of consecutive values with in that row; that is what I need.

    I have attached a sampling.

    Thanks in advance!!

    -m
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to Count Consecutive Blank Cells in a Range Depending on Today's Date
    By tophatpete in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-28-2020, 05:12 AM
  2. Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  3. 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
  4. Replies: 4
    Last Post: 01-15-2012, 12:42 PM
  5. Replies: 2
    Last Post: 09-01-2010, 07: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