How to add a condition to rank using a PivotTable in Excel. A simple rank is easy to calculate, ... Click anywhere inside the Commissions Table (B2:F13). Click the Insert tab.

Microsoft Excel will rank whatever you want automatically. Susan Harkins will show you how. ... If you’re not working with a Table object, use the following: =RANK(D3,D3:D42) ...