Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pre determine value | Excel Discussion (Misc queries) | |||
Need to find the higest alpahbetic name in a list of names | Excel Worksheet Functions | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to Determine 1st, 2nd & 3rd for a PWD | Excel Discussion (Misc queries) |