Tuesday, November 27, 2012

yogi_Capture Minimum and Maximum Of The Values That Are Successively Entered In Cell A1


                                          Google Spreadsheet   Post  #897

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 27, 2012
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?

Thanks very much for any help!
---------------------------------------------------------------------------------------
this is in reference to Domi's first question

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