With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, November 27, 2012
yogi_Capture Minimum and Maximum Of The Values That Are Successively Entered In Cell A1
user Domi Paravasilinus said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/fFvgcW2fz9Y) Two probably simple to answer questions
New to using Docs/spreadsheets and could use a little help with a couple items:
1. How do you create a cell that "keeps track" of the highest and lowest values that were ever put into another cell? Example, cell B16 gets its single number data updated every so often. Each time it updates, I want another cell to display a range indicating the lowest and highest values ever entered into B16. If the updates were made in this order: 12, 5, 12, 92, 12, 106, 32, I would see the tracking cell range shift as follows: "12-12"->"5-12"->"5-92"->"5-106".
2. How do you conditionally change a cell's background color depending on whether the value in the cell is greater or less than the value in another cell?
There are no native formulas to store successive entries in cell A1 for one to be able to recall what was ever put into a cell... so for what you want to accomplish you will have to explore doing it with Google Apps Script.
if you are open to making successive entries within cell A1 with a delimiting character, such as a space character, a comma, a tilde, etc. then for that I have provided a solution in my following