Rebase to 100

[amitvnarendra]

Hello all,

How do i rebase the number to 100 for the following data points.

Date	DPS
31/03/2010​	26.17659​
30/06/2010​	25.396716​
30/09/2010​	21.897034​
31/12/2010​	15.943348​
31/03/2011​	26.889351​
30/06/2011​	29.768863​
30/09/2011​	26.065647​
30/12/2011​	19.058805​
30/03/2012​	29.943483​
29/06/2012​	32.477073​
28/09/2012​	28.486234​
31/12/2012​	19.875019​
29/03/2013​	32.239497​
28/06/2013​	35.322653​
30/09/2013​	29.42955​
31/12/2013​	21.784299​
31/03/2014​	31.649557​
30/06/2014​	34.405436​
30/09/2014​	31.501201​
31/12/2014​	21.701111​
31/03/2015​	34.567325​
30/06/2015​	35.484178​
30/09/2015​	32.428955​
31/12/2015​	23.753755​
31/03/2016​	34.633386​
30/06/2016​	38.155567​
30/09/2016​	33.303484​
30/12/2016​	27.601265​
31/03/2017​	39.184757​
30/06/2017​	43.8626​
29/09/2017​	37.780979​
29/12/2017​	28.414565​
30/03/2018​	38.46314​
29/06/2018​	47.269659​
28/09/2018​	39.252057​
31/12/2018​	32.138036​
29/03/2019​	42.068677​
28/06/2019​	48.525459​
30/09/2019​	43.816104​
31/12/2019​	33.05139​
31/03/2020​	32.9581​
30/06/2020​	22.709805​
30/09/2020​	29.7006​
31/12/2020​	21.737203​
31/03/2021​	33.040083​

 

[JGordon11]

Do you want the average to equal 100, the minimum equal to 100, or something else?

 

[amitvnarendra]

Thank you for looking into this. I want the data to start at 100

 

[JGordon11]

Book3
	A	B	C
1	Date	DPS	Rebase 100
2	31/03/2010	26.17659	100
3	30/06/2010	25.396716	97.02072
4	30/09/2010	21.897034	83.651209
5	31/12/2010	15.943348	60.906894
6	31/03/2011	26.889351	102.72289
7	30/06/2011	29.768863	113.72323
8	30/09/2011	26.065647	99.576175
9	30/12/2011	19.058805	72.808586
10	30/03/2012	29.943483	114.39031
11	29/06/2012	32.477073	124.06915
12	28/09/2012	28.486234	108.82332
13	31/12/2012	19.875019	75.926693
14	29/03/2013	32.239497	123.16156
15	28/06/2013	35.322653	134.93986
16	30/09/2013	29.42955	112.42698
17	31/12/2013	21.784299	83.220538
18	31/03/2014	31.649557	120.90787
19	30/06/2014	34.405436	131.4359
20	30/09/2014	31.501201	120.34112
21	31/12/2014	21.701111	82.902742
22	31/03/2015	34.567325	132.05435
23	30/06/2015	35.484178	135.55692
24	30/09/2015	32.428955	123.88533
25	31/12/2015	23.753755	90.744268
26	31/03/2016	34.633386	132.30671
27	30/06/2016	38.155567	145.76218
28	30/09/2016	33.303484	127.22621
29	30/12/2016	27.601265	105.44255
30	31/03/2017	39.184757	149.69389
31	30/06/2017	43.8626	167.56422
32	29/09/2017	37.780979	144.33117
33	29/12/2017	28.414565	108.54953
34	30/03/2018	38.46314	146.93717
35	29/06/2018	47.269659	180.5799
36	28/09/2018	39.252057	149.95099
37	31/12/2018	32.138036	122.77396
38	29/03/2019	42.068677	160.71107
39	28/06/2019	48.525459	185.37731
40	30/09/2019	43.816104	167.3866
41	31/12/2019	33.05139	126.26316
42	31/03/2020	32.9581	125.90677
43	30/06/2020	22.709805	86.756163
44	30/09/2020	29.7006	113.46245
45	31/12/2020	21.737203	83.040621
46	31/03/2021	33.040083	126.21997
Sheet2

Cell Formulas
Range	Formula
C2:C46	C2	=B2*100/$B$2