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.

you can use the $A$1 absolute reference if stdev was in A1 or name a cell and
reference it.

"Engineering Intern" wrote:

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.