LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 709
Default Average a dynamic Range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to average data with a dynamic range Sharon Excel Discussion (Misc queries) 2 August 14th 08 05:16 PM
dynamic range based on criteria, within a dynamic range, passed to a function [email protected] Excel Programming 5 October 9th 07 10:13 PM
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function [email protected] Excel Programming 0 October 9th 07 05:22 PM
Dynamic average Mike D. Excel Discussion (Misc queries) 1 October 4th 07 10:05 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"