Filter

GROUPBY function: The future of COUNTIF SUMIF

Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.

Take your data analysis to the next level with intelligent filters in Excel. Find out how Slicers can improve efficiency, and accuracy.

Master Excel filtering techniques with this comprehensive tutorial. Learn how to filter and sort data in Excel with ease

Learn how to remove all the filters in Excel with just one click. This step-by-step guide will help you to improve your Excel skills

Learn the trick to add filter options for all pivot table columns. Enable the Filter menu and access filtering and sorting for every column.

One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.

The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.