How to add a condition to rank using a PivotTable in Excel A simple rank is easy to calculate, but sometimes you’ll want to accommodate a condition.