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