I would like cell A to have the max value that another cell B has ever had. How can I do that? Cell B changes value dynamically according to a =GoogleFinance()
formula (every few seconds or so).
Google Sheets – How to Update Cell Value to Max if Smaller Than Another Cell
google sheets
Related Topic
- Google-sheets – Print text associated with a value
- Google Sheets – How to Find Max Value for a Name
- Google Sheets – Populate Cells with Formulas Based on Single Cell Value
- Google-sheets – Comparing cell value 450-500 to another cell of value 475 in Google Sheets
- Google Sheets IMPORTRANGE – How to Refer to a Cell Value
- Google Sheets – Value in Cell Different from Text
Best Answer
The only way to accomplish that, is through a script, Google Apps Script that is.
Script
Trigger
Explained
The script is retrieving the two values, at 1 minute intervals, and compares them. If the "real" value if higher than the highest value, then the highest will be replaced by the "real' value.
How-to
Add the script under
Tools>Script editor
. Press the bug button to authenticate the script (as it need access to the Google Spreadsheet). SelectResources\Current project's triggers
in the script editor and set it to the screenshot given.Example
I've created an example file for you: get max value from formula
Second Best
Explained
This formula will show all the highest day values of the Google share, from the beginning of 2011. The
INDEX
formula will show only the second column and theMAX
formula will show only the highest value.