| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fixing a single cell reference keeping others dynamic
I'm trying to calculate the number of standard deviations from the mean for
each data point. I have to do this many (pehaps hundreds) of times within a given spreadsheet. My delema is that when I drag down my formula, it references another number other than the STDEV, seeing there is only that there is only one STDEV for a great number of values. How can I make Excel reference the same STDEV while still changing the data point of comparison? I having a working solution but it isn't very elegant at all. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Help creating single cell Pop-up | Excel Worksheet Functions | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| Cell Reference Math | Excel Worksheet Functions | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Threaded Mode
