There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

Analyzing-PivotTable-Data2 Clear the filter from Quarter and modify the PivotTable report to answer the question, "What are the total sales by region for each quarter?" ...

Here we have set the Top 10 Filter to Sum of Outstanding balance and set the value to 1,500,000: Our PivotTable now shows us the shortest list of customers to generate a total over £1.5m: Further ...