I have the following formula in column EY:

=AVERAGE(PERCENTRANK($EV$2:$EV$5000,EV3),PERCENTRANK($EW$2:$EW$5000,EW3),PERCENTRANK($EX$2:$EX$5000,EX3))


When I paste columns EV, EW, EX, and EY into another spreadsheet, in say column FF, the references stay the same (EV, EW, EX) when they should adapt and be referencing FC, FD, FE.

All the other formulas I use adapt to wherever I paste them, why doesn't this one? How do I fix it?

Thanks