Download Excel Start File: [ Ссылка ]

Download Excel File: [ Ссылка ]
Great Trick from circledchicken at Mr Excel Message Board: [ Ссылка ]
This video:
1. Learn about all the parts that make up a complex array formula that can find the staring position of the most consecutive ones (most items in succession, most 1s in a row):
2. Very detailed step by step look at each element that makes up this complex array formula.
3. See the functions IF, ROW, FREQUENCY, MAX, MATCH, and SMALL.

свернуть