3 tutorials tagged “dynamic-arrays”.
FILTER or QUERY in Google Sheets? A decision table, 9 side-by-side formulas, and the traps (mixed data types, case, column letters, empty results) that decide which one to use.
Getting #SPILL! "Spill range in table" in an Excel table? Fix the missing @ first, then return one value per row, move the formula outside, or convert to a range.
Why Google Sheets shows #REF! "Array result was not expanded because it would overwrite data", how to find the blocking cell, and 6 fixes with copy-ready formulas.