Popular Software Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Tutorialized ForumsTraining CenterPopular Software Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old June 8th, 2006, 02:03 PM
puj puj is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jun 2006
Posts: 2 puj New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Challenging 'AVERAGE' Advance Task - need helps

Hiya everyone,

recently i have use MS Excel in my research, and have problem to get some advance averaging task done.

The row to solve:
0.4455
0.3812
0.3234
0.5012
0.3745
0.1102
0.3455
0.3129
0.3314
0.4112
0.3099
0.4472

The thing i would like to do is to create AVERAGE for the first 3 numbers (0.4455, 0.3812, and 0.3234), then next 3 (0.5012, 0.3745, and 0.1102), and so on and so forth.. After that put the average number in the SAME ROW as 0.3812 (2nd row), 0.3745 (5th row), and so on and so forth, but in the second column. The place to put each average solution are in the exact middle row of the 3-used-averaging values. However, I cannot do it manually as the data I am analysing is having 15000 values (above just a part of it). In another words, I must use an automatic function to do it.

Can anyone helps?

Many thanks.


Regards,
Jaan

Reply With Quote
  #2  
Old June 10th, 2006, 10:25 AM
puj puj is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jun 2006
Posts: 2 puj New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
To add on, there can be more than 1 function as long as it can automatically do the average and put it in the required position.

Reply With Quote
Reply

Viewing: Tutorialized ForumsTraining CenterPopular Software Help > Challenging 'AVERAGE' Advance Task - need helps


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT