Excel Forum



Excel Array Formula Series #10: Amazing Syntax Array Trick


See how to create an array constant from values in cells. This is an amazing trick that can save tons of time when you want your array stored in memory.

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.