Please clarify your question.
J is NOT a row.
What range do you want.
Look at the MAX function and the MIN function in HELP


--
Don Guillett
SalesAid Software

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.

Thanks.