I'm using (desktop) Office 365, but you can use earlier versions of the ribbon format. It's this latter section of the article that might provide the most new material for some of you. Then, we'll discuss some problems with the results and possible solutions. In this article, you'll create a simple PivotTable and then use the built-in filter to display only the top 10 records in the data source. LEARN MORE: Office 365 Consumer pricing and featuresįortunately, Microsoft Excel has a built-in filter for PivotTables that will let you display the top (or bottom) n record. TechRepublic and the author were not compensated for this independent review. When you want to see only the top n records-filtering out all other records-you'll need a different strategy.ĭisclosure: TechRepublic may earn a commission from some of the products featured on this page. Either is reasonable when you want to view all of the data. In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet, I explain two different conditional formatting methods to highlight the top n values in a data set in Microsoft Excel. Checklist: Securing Windows 10 systems (TechRepublic Premium).
