How to determine the higest value?

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
 
R

RagDyeR

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
 
R

Ron Rosenfeld

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

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
 
R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top