Monthly Archives: January 2015

Stacking (Appending) Arrays/Ranges in Excel: Formulas versus Functions Shootout

Posted on January 16, 2015 by fastexcel

This post is a follow up to my last post Using Constant Arrays and Expressions in Excel Formulas. I will explore how some of the general purpose array-handling functions in FastExcel SpeedTools Extras compare with formulas using native Excel functions. … Continue reading →

Posted in arrays, Calculation, Lookups, Uncategorized, XLL | Tagged , , , , , , , | 9 Comments

Using Constant Arrays and Array Expressions in Excel Formulas

Posted on January 11, 2015 by fastexcel

How Excel handles array expressions and constants in single-cell and multi-cell formulas is not well documented. So here is my attempt to shed some light on the subject. What are Constant Arrays? Constant arrays are Excel formula expressions that allow … Continue reading →

Posted in arrays, Calculation | Tagged , , , , | 10 Comments