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?
Bookmarks