Would you consider using a Pivot Table?
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html#Multiple

Regards,
Ryan---
--
RyGuy


"erinlm" wrote:

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!