How-To Geek on MSN

Why I'm swapping my PivotTables for the PIVOTBY function in Excel

PivotTables are static relics; PIVOTBY is the responsive, resilient, and fully auditable future of the modern Excel professional.

Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.