Normalizing/standardizing numbers

[abberyfarm]

Hi,

I'm trying to standardize numbers in a column with this formula http://office.microsoft.com/en-us/excel-help/standardize-HP005209273.aspx

I tried to use this to standardize the the first number 17 and drag it down, but its not working?

=STANDARDIZE(F2,F2:F53,F2:F53)

Any ideas?

Here are the numbers

20
17
18
13
0
18
30
30
14
23
30
30
27
14
30
22
30
5
18
30
30
30
22
17
30
30
11
14
30
30
30
30
30
24
30
30
10
19
30
7
24
18
0
0
1
8
9
21
5
2
30
26

 

[planetpj]

Use this
=STANDARDIZE(A2,AVERAGE($A$2:$A$53),STDEV($A$2:$A$53))
or
have a cell house the Average and the StDev
if D1 Housed Average =AVERAGE($A$2:$A$53)
and
E1 housed = STDEV($A$2:$A$53)
then formula would look like
=STANDARDIZE(A2,$D$1,$E$1)

 

[abberyfarm]

Thanks, I figured it out.

I actually have to normalize data in the range A to AD repetitively. Would you know of a macro that could normalize the data by column? The number of rows is variable.

Thanks for your help

Ash