Introduction to Booleans
In this video, we’ll introduce the idea of boolean values in Excel. Boolean values are a key building block in dynamic array formulas.
Dave Bruns
Boolean operations in array formulas
In this video, we'll look at how boolean operations are used in array formulas. This is a key concept in developing more advanced dynamic array formulas...
How to convert Booleans to numbers
When working with more advanced formulas, especially array formulas, you need to know how to convert TRUE and FALSE values in Excel to their numeric equivalents, 1 and 0. In this video, we'll look at some ways you can convert TRUE and FALSE values in Excel to 1s and 0s...
Alternatives to Dynamic Array Functions
Dynamic Excel offers 6 brand new functions that solve hard problems in Excel like sorting, filtering, and working with unique values. For those not using Office 365, this page provides some alternative formulas that work in older versions of Excel.Read more
What is an array?
The term "array" comes from programming, but you'll hear it often in the context of more advanced Excel formulas. In this video, we'll answer the question "what is an array?" ...
XLOOKUP with multiple lookup values
In this video, we'll set up XLOOKUP to return multiple values in a dynamic array, by providing a range of lookup values instead of a single lookup value...
Basic XLOOKUP approximate match
In this video, we’ll set up the XLOOKUP function to perform an approximate match in order to calculate a quantity based discount.
Nesting dynamic array formulas
In this video, we'll look at how to nest dynamic array functions together to create powerful and dynamic solutions...
Dynamic arrays are native
In this video we'll look at how dynamic array behavior is native and deeply integrated in Excel. Even older functions can use this new feature...
Spilling and the spill range
In this video, we’ll look at a core concept in dynamic array behavior - spilling and the spill range.