Could someone please help me with 2 worksheet formulas?:
1) I need to count the maximum consecutive TRUEs in a single column, in a descending-order worksheet that cannot be sorted in ascending order, for n rows beginning in row 3, using Excel 2000, where n is user defined.
2) I need to count the maximum consecutive TRUEs in a single column, in a descending-order worksheet that cannot be sorted in ascending order, for n minutes based on a timestamp in another column, beginning in row 3, using Excel 2000, where n is user defined.
I've already calculated the total TRUEs by n rows and n minutes, but I need to also count the max consecutive TRUEs, and I'm completely stumped.
Attached is a workbook with what I've already done.
Bookmarks