Thanks for the reply Eric.
Match results are recorded per row in one sheet.
In another sheet there are the calculations for the ranking.
It is a ranking based on RPI (rating percentage index) (25% team winning percentage, 50% opponents’ average winning percentage, and 25% opponents’ opponents’ average winning percentage) so every new game result modifies the entire RPI column not only the points of the teams involved.
This is why I would like to “copy” the data of the RPI column (in other column) before the result of a new game is inserted.