I'm using a spreadsheet which is streaming numeric data.
I need a formula which will record the maximum value ever recorded in a certain cellso that, for example, i could leave the data streaming over night, then check it in the morning to see what the maximum value reached in that cell during the night.
Then i need a seperate formula to record the minimum value.
Can anyone help?
Thanks in advance,