Yes please Ron.
Thank you in advance
Blue.jag

"Ron Coderre" wrote:

Are you saying that the list of numbers changes every day, but you still want
to know the largest value that the range of numbers EVER had during the year?
Even though that number may not exist in the latest version of the data?


***********
Regards,
Ron

XL2002, WinXP-Pro


"blue.jag" wrote:

Thanks Ron.
Your answer returns the maximum for the current column, but when the column
of figures changes tomorrow and every day for the next 364 days, I still need
to retain one maximum figure over the whole 365 days.
Your suggestion only gives me the max one day at a time and then that max is
gone the next day!

"Ron Coderre" wrote:

If the numbers are in Row 1:

B2: =MAX(1:1)
OR
B2: =MAX(A1:Z1)

If the numbers are in Col_A:

B2: =MAX(A:A)
OR
B2: =MAX(A1:A100)

Adjust range references to suit your situation

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"blue.jag" wrote:

In Exel, how can I record the highest value (automatically) from a row of
numbers that changes each day. At the end of the year I still need to have
the highest number recorded over the whole year even though each previous
day's numbers disappear.