How to determine the higest value?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Does anyone have any suggestions on how to determine the highest [High] value
for each week?

For example 1,
the highest [High] value between 11/19/07 and 11/23/07 is 111.05, return in
cell E2 at the end of week.

For example 2,
the highest [High] value between 11/13/07 and 11/16/07 is 111.38, return in
cell E7 at the end of week.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Row Weekday Date Value
1 1 11/26/07 108.17
2 5 11/23/07 108.17
3 4 11/22/07 108.54
4 3 11/21/07 108.54
5 2 11/20/07 110.05
6 1 11/19/07 110.05
7 5 11/16/07 111.05
8 4 11/15/07 110.78
9 3 11/14/07 111.38
10 2 11/13/07 110.31
11 5 11/09/07 110.900
 
The Max() function is what you'll need to use.
However, what cells to reference within the Max() function depends on your
data configuration.

Post back with how your datalist is set up.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Does anyone have any suggestions on how to determine the highest [High]
value
for each week?

For example 1,
the highest [High] value between 11/19/07 and 11/23/07 is 111.05, return in
cell E2 at the end of week.

For example 2,
the highest [High] value between 11/13/07 and 11/16/07 is 111.38, return in
cell E7 at the end of week.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Row Weekday Date Value
1 1 11/26/07 108.17
2 5 11/23/07 108.17
3 4 11/22/07 108.54
4 3 11/21/07 108.54
5 2 11/20/07 110.05
6 1 11/19/07 110.05
7 5 11/16/07 111.05
8 4 11/15/07 110.78
9 3 11/14/07 111.38
10 2 11/13/07 110.31
11 5 11/09/07 110.900
 
Does anyone have any suggestions on how to determine the highest [High] value
for each week?

For example 1,
the highest [High] value between 11/19/07 and 11/23/07 is 111.05, return in
cell E2 at the end of week.

For example 2,
the highest [High] value between 11/13/07 and 11/16/07 is 111.38, return in
cell E7 at the end of week.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Row Weekday Date Value
1 1 11/26/07 108.17
2 5 11/23/07 108.17
3 4 11/22/07 108.54
4 3 11/21/07 108.54
5 2 11/20/07 110.05
6 1 11/19/07 110.05
7 5 11/16/07 111.05
8 4 11/15/07 110.78
9 3 11/14/07 111.38
10 2 11/13/07 110.31
11 5 11/09/07 110.900
Click to expand...

You might be interested in a Pivot Table (Data/Pivot Table)

I got this output:

Date Maximum Value
<11/12/2007 $110.90
11/12/2007 - 11/18/2007 $111.38
11/19/2007 - 11/25/2007 $110.05
11/26/2007 - 11/27/2007 $108.17

Select a cell in your data table.

Data/Pivot Table and Chart Report
<Finish>

Drag Date to the Row area;
Drag Value to the Data area

Right click on Value
Field Settings
Summarize by: Max
Change Name to something pleasing

Right Click in the Date area
Group and Show Detail
Group
By: Days
Number of Days: 7
Select a Starting at: date that is a day at the beginning of your week. It
does not need to exist in your table.

Choose a pleasing format from the report format menu.


--ron
 
Well I'll be darned!

Didn't scroll down past the OP's signature, and missed the whole data
description!<g>

Was wondering how you guys could make your suggestions.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

The Max() function is what you'll need to use.
However, what cells to reference within the Max() function depends on your
data configuration.

Post back with how your datalist is set up.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Does anyone have any suggestions on how to determine the highest [High]
value
for each week?

For example 1,
the highest [High] value between 11/19/07 and 11/23/07 is 111.05, return in
cell E2 at the end of week.

For example 2,
the highest [High] value between 11/13/07 and 11/16/07 is 111.38, return in
cell E7 at the end of week.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Row Weekday Date Value
1 1 11/26/07 108.17
2 5 11/23/07 108.17
3 4 11/22/07 108.54
4 3 11/21/07 108.54
5 2 11/20/07 110.05
6 1 11/19/07 110.05
7 5 11/16/07 111.05
8 4 11/15/07 110.78
9 3 11/14/07 111.38
10 2 11/13/07 110.31
11 5 11/09/07 110.900
 
Back
Top