Array Formulas


Array Formulas - doing lots of things at once


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.

Array Formulas

- what is the point of Array Formulas or CSE
Array Formulas and Sumproduct - sumproduct() is just really a disguised array formula
Array Formulas and Bit Twiddling - Extreme array formulas to perform complex logical operations

Array 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