Excel 2016 – 3.5.4 – Using Rank We’re going to use this pre-created PivotTable function to rank our Sales in order, by Location.