running maximum (newbie question)
Will someone please help with the following question:
I have a column of say 200 values.
In row J I want the highest value that has occurred in rows 1, 2,3...
up to J.
I assume the answer for the minimum value would be similar.
Thanks.
|