How to normalize a simple array (1 column) of 1000+ cells

I tried:

=STANDARDIZE(A2,A3,A4)

A2 the array that I want to normalize (serie of values)

A3 the Arithm. Mean (Average) for the target array (the correct array, same data type)

A4 STDEVP for the target array (the correct array).

But not sure that this formula is for normalizing (shift data set till it fits the histogram bell shape of the target data set)

I was able to do the normalization by hand using Histogram in Excel Statistics and then (linear) shifting my data (adding a constant) till I had a good fit when overlaying the two histograms, but I like to do it with a formula.

Below a sample of the data: the first column is my model (target) the second the data to be normalized and the third column after I subtracted 10 to the second column so it fitted in the histogram of the first column (cannot attach the Excel file as it is too large)

102.383 115.18 105.18

102.258 128.56 118.56

101.427 140.58 130.58

106.019 119.7 109.7

105.065 123.18 113.18

105.396 128.27 118.27

103.949 130.46 120.46

104.874 138.82 128.82

104.249 121.39 111.39

105.333 126.47 116.47

101.205 128.47 118.47

102.703 125.53 115.53

104.45 126.81 116.81

108.036 132.21 122.21

107.87 116.57 106.57

101.882 119.16 109.16

100.955 123.27 113.27

101.454 122.23 112.23

104.486 121.46 111.46

107.608 122.48 112.48

104.489 112.41 102.41

111.009 104.62 94.62

111.839 116.94 106.94

112.713 126.64 116.64

103.57 128.75 118.75

103.57 126.07 116.07

104.693 99.15 89.15

108.814 126.24 116.24

112.006 124.5 114.5

112.297 120.46 110.46

113.92 120.91 110.91

108.477 136.96 126.96

I tried:

=STANDARDIZE(A2,A3,A4)

A2 the array that I want to normalize (serie of values)

A3 the Arithm. Mean (Average) for the target array (the correct array, same data type)

A4 STDEVP for the target array (the correct array).

But not sure that this formula is for normalizing (shift data set till it fits the histogram bell shape of the target data set)

I was able to do the normalization by hand using Histogram in Excel Statistics and then (linear) shifting my data (adding a constant) till I had a good fit when overlaying the two histograms, but I like to do it with a formula.

Below a sample of the data: the first column is my model (target) the second the data to be normalized and the third column after I subtracted 10 to the second column so it fitted in the histogram of the first column (cannot attach the Excel file as it is too large)

102.383 115.18 105.18

102.258 128.56 118.56

101.427 140.58 130.58

106.019 119.7 109.7

105.065 123.18 113.18

105.396 128.27 118.27

103.949 130.46 120.46

104.874 138.82 128.82

104.249 121.39 111.39

105.333 126.47 116.47

101.205 128.47 118.47

102.703 125.53 115.53

104.45 126.81 116.81

108.036 132.21 122.21

107.87 116.57 106.57

101.882 119.16 109.16

100.955 123.27 113.27

101.454 122.23 112.23

104.486 121.46 111.46

107.608 122.48 112.48

104.489 112.41 102.41

111.009 104.62 94.62

111.839 116.94 106.94

112.713 126.64 116.64

103.57 128.75 118.75

103.57 126.07 116.07

104.693 99.15 89.15

108.814 126.24 116.24

112.006 124.5 114.5

112.297 120.46 110.46

113.92 120.91 110.91

108.477 136.96 126.96

## Comment