+ Reply to Thread
Results 1 to 1 of 1

Count number of consecutive cells

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    arnhem
    MS-Off Ver
    Excel 2010
    Posts
    4

    Count number of consecutive cells

    My goal is to look at a row of numbers and count the number of consecutive cells that greater than 1. while ignoring 1 cells this cell is lower than 1 that may be in between consecutive cells. This can be a inaccurancy.

    Now i got this:
    =MAX(FREQUENCY(IF(C4:C11591>1;ROW(C4:C11591));IF(C4:C11591<1;ROW(C4:C11591)))).

    This function count only the number of consecutive cells but it don't ignore if one cell is lower than 1 in a row.

    In the excel file you can see more details about the problem.

    Can somebody help me?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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