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: 27
Default help writing macro


Name Norm Qty mean std dev CV
A 137.4804
B 0
C 101.5471 79.67583333 71.3020289 89


I have to calculate the mean, standard deviation and coefficient of
variation for this table. so the calculations are for the set ABC. I can
record a macro to do this for me but I have an excel spreadsheet with about
1000 of these groups. Is there a way to apply this macro to every third
row??? So I dont have to copy and paste each of the formulas the entire
length of the spreadsheet??

thanks
 
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
VBA-writing a macro Don Guillett[_4_] Excel Programming 1 August 31st 04 01:49 PM
Need Help writing a macro TwEaKFrEaK[_4_] Excel Programming 1 August 24th 04 10:16 PM
Help writing a macro alldreams Excel Programming 0 June 4th 04 08:24 AM
help in writing a macro slim[_2_] Excel Programming 1 February 13th 04 01:41 AM
Macro Writing Help? Richard[_22_] Excel Programming 2 December 31st 03 07:39 PM


All times are GMT +1. The time now is 08:11 PM.

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"