Many people have a love hate relationship with what is perhaps Excel's most powerful capability.Normally you dont use them enough to become completely comfortable with them, but when you do you wish you had more opportunity to use them.
- what is the point of Array Formulas or CSE
Array Formulas and Sumproduct - sumproduct() is just really a disguised array formulaArray Formulas and Bit Twiddling - Extreme array formulas to perform complex logical operationsArray formulas and large ranges - some cautions on performance
Optimizing the array formula - and some alternatives
Leveraging sorted data with Match - and a solution
The birthday problem