Fixing a single cell reference keeping others dynamic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top