Excel is evolving with dynamic arrays. Get familiar with them through our tutorials. This page lists every Excel tutorial on InfoInspired
Create a Calendar in Excel with a One-Line Dynamic Array Formula
Excel: Month Name to Number & Number to Name
EXPAND + Stacking: Expand an Array in Excel
Creating Custom Descending Sequence Lists in Excel
Running Total By Month in Excel
Get Top N Values Using Excel’s FILTER Function
XLOOKUP in Excel: Working with Visible Rows in a Table
Sum Values by Month and Category in Excel
Sum Values by Categories in Excel
Filter Data from the Previous Month Using a Formula in Excel
Excel Word Count: Beyond SUBSTITUTE
Sum by Quarter in Excel: New and Efficient Techniques
Sum By Month in Excel: New and Efficient Techniques
How to Create An In-Cell Progress Bar in Excel
Sum by Week Number in Excel (Dynamic Array Formula Included)
Combine Two Tables in Excel Using a Dynamic Array Formula
Excel VLOOKUP with Multiple Criteria and 2D results (Dynamic Array)
Excel BYCOL Lambda Helper Function
Excel BYROW Lambda Helper Function
Excel: Search Multiple Keywords in a Cell (New!)
Remove Case Sensitive Duplicates in Excel
Creating a Running Balance with Dynamic Array Formulas in Excel
Split Text to Columns Using a Formula in Excel (Dynamic Array)
Unpivot Excel Data Fast: Power Query & Dynamic Array Formula
XMATCH vs MATCH in Excel (New vs Old)
Flip a Table Vertically in Excel (Includes Dynamic Array Formula)
Custom Sort in Excel (Using Command and Formula)
Running Count of Occurrences in Excel (Includes Dynamic Array)
Address of the Last Non-Empty Cell Ignoring Blanks in a Column in Excel
Running Total Array Formula in Excel [Formula Options]