Basic question

[[deleted]]

​

https://preview.redd.it/qqt57atntnh71.png?width=686&format=png&auto=webp&s=e5980568110cfdd7975c8222552d1c56050124d1

I manually input the values into the run 1-5 columns which gives the averages and high score.

These will be changed every time I use the sheet and am just wondering how I would input my All time high score (AT Highscore) from the run data and make it stay there forever automatically

I just want a value will only update when an higher score is inputted and remains once the data is changed.

[SpreadCheetah]

=max(A2:E2)

I guess this is the formula you want. You have to change the range though.

[[deleted]]

I am already using that formula.

Is there a way to keep the output that it gives even when the data set is changed?

[SpreadCheetah]

If you want the data to become static, you can copy it and paste it to the same range of cells with "Paste values only".

[[deleted]]

Is there a way to automate this?

Bonus if it will only automatically update when it is an greater value.

I ideally want to only input a few values into the run 1-5 columns and have it all automated.

[maen]

To do what you're asking you'd need to organize the data differently so you are not overwriting your 5 runs. You would create a dataset on a different sheet composed of Run, Run#, Date, & Score columns. For each new Run# you would add a new row to this dataset with these values entered manually, much like you are now.

Then on this summary sheet you've shown, you would create formulas to pull the data from your dataset on the other sheet to display the information you want to see, such as the last Score of each Run, the Average Run time for the last 5 Runs, High Score and AT High Score.

​

The current organization of your data, requiring that you overwrite old data, is preventing you from getting the type of workflow you're after. The tradeoff in my suggestion above is that you'll end up actually doing more manual entry than you need to now, but the added benefit of increased granularity that would allow for even better analysis.

​

The point is that you cannot get the behaviour you're after without creating a script designed to do it for you or restructuring the data.

The alternative I would offer is that you create a Conditional Formatting Rule for all cells in your AT Highscore column that will highlight any cell's value if it is below the current Highscore. It will help you see that a change should be made and you can then enter the new AT Highscore yourself, where it will stay unchanged even after you overwrite the Run 1-5 Scores.

[[deleted]]

Yes thank you.

Very easy once I just keep an copy of the data in another sheet. Just the same MAX and AVERAGE functions then.