How to copy down a rank formula for converting pivot table values to ranks

Hi ChrisMacGC 

if the cell reference does not change during copy, I assume that GETPIVOTDATA function is used in your file. And this function uses per default static references.

If this is the case in your file, you could turn off GETPIVOTDATA. Just put your active cell somewhere within your pivot table and select from the menu "PivotTable Analyze | Options | Generate GetPivotData"

(this option should be unchecked then)

Alternatively, when creating your RANK formula, do not click into the pivot table (which causes the GETPIVOTDATA function to be used), but instead just enter the cell reference of the first value. This one should update when you copy it down to all the other rows.