+ Reply to Thread
Results 1 to 2 of 2

Count # Cells Until Next TRUE/1 Value is Found

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    33

    Count # Cells Until Next TRUE/1 Value is Found

    I am trying to find a formula that counts the # of cells until the next TRUE or "1" value is found. Please see "Target Output" in attachment. Blank cells can be any value. A simple MATCH function would seem to work in conjunction with OFFSET, but since there is a text header in A1 it always returns an error. Thanks in advance!

    Count # cells until next true value.xlsx

  2. #2
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: Count # Cells Until Next TRUE/1 Value is Found

    In B2 enter and copy down:

    =IF($A2=1,MATCH(1,A3:$A$38,0),"")

    The last output which is #N/A looks to me more appropriate.

+ 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. Return TRUE if 'part text' found in cell range
    By AnnieM in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-23-2014, 05:10 AM
  2. Count only if 2 cells are True on a second sheet
    By matrixpom in forum Excel General
    Replies: 2
    Last Post: 04-25-2012, 10:56 PM
  3. True Word Count
    By VegasL in forum Excel General
    Replies: 4
    Last Post: 09-26-2011, 01:30 PM
  4. Replies: 2
    Last Post: 08-02-2006, 06:10 PM
  5. Count if 2 conditions are true
    By Thrava in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  6. [SOLVED] Count if 2 conditions are true
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2005, 11:05 AM
  7. [SOLVED] Count if 2 conditions are true
    By Thrava in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  8. [SOLVED] Count if 2 conditions are true
    By Thrava in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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