Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help writing macro
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. "Alison" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA-writing a macro | Excel Programming | |||
Need Help writing a macro | Excel Programming | |||
Help writing a macro | Excel Programming | |||
help in writing a macro | Excel Programming | |||
Macro Writing Help? | Excel Programming |