I have to do some SD calculations, however Excel will
only allow for 30 groups to be evaluated, I have 120
groups to evaluate, any ideas?
Are you using ranges to hold the values you want to analyze? If so, you could
replace formulas like
=STDEV(A1,A2,A3,A4,B1,B2,B3,B4)
with
=STDEV(A1:B4)
You could replace other references like
=STDEV(A1,B2,C3,D4,E5,F6,...)
with
=STDEV((A1,B2,C3,D4,E5,F6,...))
the last using a reference to a multiple area range, which would count as a
*single* argument.
If these don't exactly match your needs, you might consider pasting one of your
formulas (AS PLAIN TEXT!) into a follow-up so the rest of us don't have to guess
what you're doing.
