Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I perform a different formula on the same cell range?
I would like to first take the mean of a column of data, then the standard
deviation of the same data. The two ways I have thought of doing this are (for example): 1. First type AVERAGE and highlight (A1:A5) then copy the text (A1:A5) and paste it in the next cell and type STDEV 2. First type AVERAGE and highlight (A1:A5) then go back and put in the absolute reference dollar signs ($A$1:$A$5) then fill across to the next cell and then change to STDEV Both are getting tedious and too repetitive for the number of times I need to do this, while I think the length of the column changes too often to create a macro. Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I perform a different formula on the same cell range?
Would you consider using a Pivot Table?
http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html#Multiple Regards, Ryan--- -- RyGuy "erinlm" wrote: I would like to first take the mean of a column of data, then the standard deviation of the same data. The two ways I have thought of doing this are (for example): 1. First type AVERAGE and highlight (A1:A5) then copy the text (A1:A5) and paste it in the next cell and type STDEV 2. First type AVERAGE and highlight (A1:A5) then go back and put in the absolute reference dollar signs ($A$1:$A$5) then fill across to the next cell and then change to STDEV Both are getting tedious and too repetitive for the number of times I need to do this, while I think the length of the column changes too often to create a macro. Any suggestions? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I perform a different formula on the same cell range?
On Apr 9, 12:40 am, erinlm wrote:
I would like to first take the mean of a column of data, then the standard deviation of the same data. The two ways I have thought of doing this are (for example): 1. First type AVERAGE and highlight (A1:A5) then copy the text (A1:A5) and paste it in the next cell and type STDEV 2. First type AVERAGE and highlight (A1:A5) then go back and put in the absolute reference dollar signs ($A$1:$A$5) then fill across to the next cell and then change to STDEV Both are getting tedious and too repetitive for the number of times I need to do this, while I think the length of the column changes too often to create a macro. Any suggestions? Thanks! If you do virtually the exact same calculation frequently in different files, why not just save a blank copy with your formulas in place and reuse from there? You can add rows very quickly for different length columns. Or use a dynamic named range which will always pick the full column of data. Also, do you know how to copy with the mouse? Click and drag from the lower right corner of the cell you want to copy. Usually much faster than Copy/Paste with other methods. 3rd speed item; while you are entering the range, press F4 to toggle between all the $ absolute reference choices quickly. Faster than manually typing each $. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function does ^ perform in a formula | Excel Worksheet Functions | |||
Reference a Macro to perform Cell formula | Excel Discussion (Misc queries) | |||
what excel formula will perform a running subtract from one value | Excel Discussion (Misc queries) | |||
Using a formula to perform multiple functions. | Excel Discussion (Misc queries) | |||
Reference range of cells and perform subtraction or nothing depending on contents | Excel Worksheet Functions |