BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.
The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is ...