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.

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.

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.

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.

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.

OK...more questions (you saw that coming, right?)

By any chance, is it possible/practical to maintain a separate row of data
for each day so that all days will be stored in the same worksheet? That
would be the simplest approach. (I'm hoping for a YES on this one)

If NO, then the alternatives are much less attractive:

-Data Consolidate (Not exceptionally difficult, but is limited to structured
data and availability of historical workbooks. Can be particularly annoying
to maintain, but there are procedural workarounds to simplify the
effort...see my "Manual copy/paste_values comment, though)

-Linked workbooks (something I only do as a last resort)

-Manual copy/paste_values (I loathe "procedural" solutions....they are
always impacted by the same hardware problem: A loose nut in front of the
keyboard!)

-VBA processing of each day's data (somewhat of a mini-project...plus is
there somebody who will understand/maintain the model?)

All are doable, though....so, let us know what you prefer.

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

XL2002, WinXP-Pro


"blue.jag" wrote:

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.