wrote in message
ups.com...
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.

In row 1, you need the formula =MAX(A$1:A1) [assuming that your data values
are in column A], and copy this down in rows 2 to 200.
As you say, MIN() would work similarly.
--
David Biddulph