Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
HI,
My data is as follows: CW001P01-SH-C: Time Duration Partition Utilization % 20/03/2010 23:56 900 86.3521441 21/03/2010 00:11 901 86.35425916 21/03/2010 00:26 899 86.35738494 21/03/2010 00:41 902 86.3596435 21/03/2010 00:56 901 86.36061494 21/03/2010 01:11 901 86.33145463 21/03/2010 01:26 912 86.33382161 and then again CW001P03-SH-C: Time Duration Partition Utilization % 20/03/2010 23:56 900 80.56180556 21/03/2010 00:11 901 80.57303517 21/03/2010 00:26 898 80.59451559 21/03/2010 00:41 903 80.59689922 21/03/2010 00:56 901 80.59860572 and so on down to 90000 rows. I need to average each of the sections of data based on the CW number. The number of rows for each CW number is dynamic. I had the code to do this but I crashed by PC and lost the info. Can someone please help.Thanks, Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to average data with a dynamic range | Excel Discussion (Misc queries) | |||
dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
Dynamic average | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |