| 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! |
| 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 | |||
Threaded Mode
