i need columns to stay the same after they are changed

[John Henworth]

hELLO
I use a SUM PRODUCT to obtain the weeks score,
What I want is Column T to not change when this weeks games are finished and I put next weeks games in and delete all the selections for this week so I can enter people new selections also is there a way of calculating the league positions .Up to now I do it with the manual sort

[AliGW]

At the end of the week, copy - paste special - values.

[John Henworth]

Hello AliGW
Thanks for your quick response.
I am just learning Excel and dont quite understand what you are meaning,
Just read at the bottom of your post, it says you are self taught, must have taken some time to get to your level
John

[AliGW]

OK - I didn't want to patronise you. Some people take offence if we assume no real knowledge!

Select the range in column T containing the formula - with the range selected, right-click - copy - right-click - paste special - paste values.

Just read at the bottom of your post, it says you are self taught, must have taken some time to get to your level

I started learning through work back in the mid-90s, but I've learned a lot by helping out here since 2013.