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 bec…>>   (more…)

Original post by Chris Gilmer