Download Files:
[ Ссылка ]
See how to find a perfect match of 6 successive items using the AND and IF functions in two formulas:
1) Non-array formula
2) Array formula (much shorter and better formula, but requires Ctrl + Shift + Enter).
![](https://i.ytimg.com/vi/2T3FJgp0QS8/mqdefault.jpg)
Download Files:
[ Ссылка ]
See how to find a perfect match of 6 successive items using the AND and IF functions in two formulas:
1) Non-array formula
2) Array formula (much shorter and better formula, but requires Ctrl + Shift + Enter).