i want excel to compare the Current winning % with the previous winning % for each player

The drawback with your approach is that you do not know what the previous %age would have been. If player 3 plays another game and wins it, you will change the 10 in B4 to 11 and the 6 in C4 to 7, giving a current percentage of 64%. However, you do not know at that point what his previous result was because you have overwritten it.

A layout that would facilitate this would be to have the result of each game in a separate column, maybe using W for win and L for Lost (and maybe also D for Draw if applicable), then you can count the number of non-blank cells to get the number of games, and also count the number of W's to get the number of wins. You can also count up to the previous column to get the previous win rate.

Hope this helps.

Pete

Thanks mate for the help. I was afraid that it wasnt possible to do that, i will try it your way!