Fixing a single cell reference keeping others dynamic


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.
 
Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top