ExcelBanter - Excel 2007 Pivottable Rank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2007 Pivottable Rank (https://www.excelbanter.com/excel-worksheet-functions/222326-excel-2007-pivottable-rank.html)

Peter

Excel 2007 Pivottable Rank

Is there a way with pivottable in Excel 2007 to add the rank within each
group? I have table with location and products going down and Dollars and
Units across the top. I would like to add a fact that show the rank for the
products within the location.

--
Peter

All times are GMT +1. The time now is 03:22 PM.