learn “Rank Smallest to Largest” and “Rank Largest to Smallest” in the pivot table. Using this Excel assigns rank according to value automatically.
Category: MS Excel Tutorial
One of the best tutorials on MS Excel. This is the only tutorial that contains from basic topics to advance.
learn about the Subtotals & Filters tab in Field Settings of Row Label in PivotTable