help writing macro

[Guest]

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

 

[Guest]

You don't need a macro for that...

Select the range of cells including the 2 rows above your formulas and drage
the entire range down the lenght of the sheet. That will copy the formula to
every third row... If you want that in code just record a macro of that
process. A somewhat better way would be to highlght the range and then plce
your cursor over the bottom right hand corner of the range to get the cross
hair. Hold down the Ctrl key and double click.