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
|