Array Formulas without Ctrl-Shift-Enter

If you're an expert spreadsheet user, you might be familiar with the powerful and obscure feature known as array formulas. They're powerful because they let you replace an entire column of formulas with a single array formula that does all the calculations in one place. And they're obscure because you've always had to hit Ctrl-Shift-Enter to create one, and, well, who's ever going to discover that on their own? (Read more...)