01-14-2019 08:06 PM
01-14-2019 08:06 PM
how do you set up a spreadsheet where formulas can be prevented from updating, to be used later. Example a formula is = sum a column and store the value in say a1.
another entry later needs to have the current value in a1 as a new number is entered in the column of sums which creates an updated value. There must be a way to have a1 remain as current or someway to have that value available from somewhere else.
01-14-2019 10:05 PM
01-15-2019 07:52 AM
Thank you for the answer.
I am totally new at this and was trying to create a bowling league application.
I created one sheet with the updated stats of all bowlers and league standings.
Another sheet was for entering the scores on a weekly basis, according to a schedule.
As they are updated the league standings are updated.
The problem is that some stats are based on the bowlers previous weeks average, and it updates as soon as current data is entered, and skews the data for some scores.
Is there a way to save that previous week’s average data someplace in order to use it on the current weeks information?
Talk to you soon,
01-16-2019 03:59 PM
01-17-2019 07:42 AM - edited 01-18-2019 12:54 PM
The following is a layout of the seasonal stats.
The problem is the average column is updated whenever new games are entered into the weekly stats. (Second sheet below)
Is there a way to preserve the average column value (AVE) somewhere after each weekly input so it can be used to calculate the hcp column and the game1hcp to game3hcp columns on the second sheet the following week.
|Hits & Misses||96||Game 1||Game 2||Game 3||Team Series Scratch||Team SeriesHcp||Team Game||Team Game Hcp||Game1Hcp||Game2Hcp||Game3Hcp||# games||Average|
by PNEME82 on August 10, 2020
by cmlobo_sr_sf on August 10, 2020
by _aeung on August 10, 2020
by Guy Hunkin on August 05, 2020
by Sonia Atchison on July 24, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020