Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be ...

If Excel filter is not working after certain row, for merged cells, on large files or on protected sheet, then see this post.

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 ...