Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

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.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

By using the FILTER function in conjunction with SCAN, you can quickly and easily drill down into your data and uncover valuable insights. Another essential function to consider is CHOOSE.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.