I use Excel for technical stuff.
- First, could you PLEASE make it so that if I type
A1 = avg(range); Excel knows what I mean? You don't make me type out "StandardDeviation", Excel knows what "stdev(range)" means, please let us use "avg" as an abbreviation for "average"!
2. Suppose I have a discontinuous range of cells that I want to average, e.g.
cell A1=average(B1,C1,D1)
If I want the standard deviation as far as I know I have to either retype the range OR select and copy the range from A1 and then paste it in to my formula. Both these option are a pain.
Make Excel smart! If
A1=average(range)
then if I type
A2=stdev(A1)
Excel should pop up a dialog box that says "Did you want me to use the range that was used in A1?" Then I can answer YES or NO. This could be generalized to any function that wants a range - if a single cell is entered as the range Excel asks if I want to use the range that is in that single cell. Simple but effective!
Bob
Other recent topics
