Average various variable ranges
 

Hi, I posted this question before, but I cannot find the thread of it
anywhere, so I am posting it again. If it is duplicated, please forgive me. I
have 90 000 rows of data that is in the following format:
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
CW001P12-SH-F:
Time Duration Partition Utilization %
20/03/2010 23:56 900 2.55062256
21/03/2010 00:11 901 2.55062273
21/03/2010 00:26 899 2.55062265
21/03/2010 00:41 902 2.55062264
21/03/2010 00:56 901 2.55062273
21/03/2010 01:11 901 2.55062273
21/03/2010 01:26 912 2.55062277
and so on, one below the other. I need to average each Utilisation range
for each "CW" number. The ranges vary in length. Please could someone help me
with this. I crashed my PC where I had the code that usedf to wrok, so I knwo
it is possible. THANK YOU.

Average various variable ranges
 

Bob Phillips provided a response he
http://www.microsoft.com/office/comm...a-9bb21ffc6395


"Richard" wrote:

Hi, I posted this question before, but I cannot find the thread of it
anywhere, so I am posting it again. If it is duplicated, please forgive me. I
have 90 000 rows of data that is in the following format:
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
CW001P12-SH-F:
Time Duration Partition Utilization %
20/03/2010 23:56 900 2.55062256
21/03/2010 00:11 901 2.55062273
21/03/2010 00:26 899 2.55062265
21/03/2010 00:41 902 2.55062264
21/03/2010 00:56 901 2.55062273
21/03/2010 01:11 901 2.55062273
21/03/2010 01:26 912 2.55062277
and so on, one below the other. I need to average each Utilisation range
for each "CW" number. The ranges vary in length. Please could someone help me
with this. I crashed my PC where I had the code that usedf to wrok, so I knwo
it is possible. THANK YOU.