How to determine the higest value?
 

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

How to determine the higest value?
 

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 !
-----------------------------------------------------------------------------------------------

"Eric" wrote in message
...
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

How to determine the higest value?
 

How about =IF(A2=5,MAX(C2:C6),"")

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
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

How to determine the higest value?
 

On Sat, 1 Dec 2007 07:11:01 -0800, Eric wrote:

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

How to determine the higest value?
 

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 !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
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 !
-----------------------------------------------------------------------------------------------

"Eric" wrote in message
...
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