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
Bookmarks