N
neuron
I am making a spreadsheet where I add one new data point to a colum
each day (e.g. number of cars I honked at yesterday)
I also have a box that calculates statistics based on the data entere
(e.g. total number of cars, percent increase over time, etc)
How can I assign a formula in the "statistics box" that will updat
when I enter in the new value in the "data column"? Is there som
general notatation that will tell the cell to search for the mos
recent value in a column of data?
Thanks for your comments
each day (e.g. number of cars I honked at yesterday)
I also have a box that calculates statistics based on the data entere
(e.g. total number of cars, percent increase over time, etc)
How can I assign a formula in the "statistics box" that will updat
when I enter in the new value in the "data column"? Is there som
general notatation that will tell the cell to search for the mos
recent value in a column of data?
Thanks for your comments