I’m reviewing the topic of Array formulas and found the Calc Guide a bit shallow, and bring here the suggestion to review and improve the contents of  .
The web can supply a lot of examples and advances use of arrays for the competition, but of course, we must write in our own words. Some interesting examples in .
And also the so called “implicit intersection” of array formulas, which is quite interesting (google it!).