Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to add a rank to a PivotTable in Excel 2003, 2007, and 2010. For more information, visit www.datapigtechnologies.com . Adding Rank in Excel 2003/2007 Step 1: Sort your pivot table on the data measure you are trying to rank. Step 2: Add a Calculated Field that will have the formula =1 . This will essentially assign a value of 1 to each row. Step 3: Right-click on your newly created calculated field and go into its Value
Read More...
Read the complete post at http://blogs.msdn.com/b/excel/archive/2010/11/02/add-rank-to-pivottable.aspx
Posted
Nov 02 2010, 03:25 AM
by
Microsoft Excel 2010