Q. How do I use the FILTER function in Excel, and how is this an improvement over the filter feature? A. The FILTER function was introduced five years ago as part of the Excel Dynamic Arrays rollout.

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Excel is one of those tools that we all know and use, but let’s be honest—most of us barely scratch the surface of its true potential. Sure, you’ve probably mastered the basics like SUM or AVERAGE, ...

To make the most of the UNIQUE function, you should make sure your array is in an Excel table. By using a table name rather ...

How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...