Tip Printed from ExcelTip.com

---

Displaying the Top/Bottom N Items in Excel 2007


To display the top/bottom N items:

Select a cell in a Row Labels field -> right-click, select Filter -> Top 10.