Your dataset may be an embarrassment of riches, but sometimes more is less. Every spreadsheet user knows that their data often warehouses more information than they need right now, and could do with a bit of incisive, if temporary, trimming.
And Excel’s new dynamic array FILTER function is very much up to that task. And as with SORT and SORTBY, FILTER contributes a set of formula-centered solutions to a classic spreadsheet chore that’s been handled heretofore by a potpourri of tools, for example, pivot ...
