hello,
I am new on the forum and was wondering if someone could help me.
I have a set of data, imports and exports every year from 2000 to 2013.
as follows
year exports imports
2000 269.6 287.8
2001 277.7 301.1
2002 293.1 319.0
2003 305.8 338.8
and so on
I am asked to rebase the year 2010 at 100 for both exports and imports. Could you please help me figure out how to do that in excel.
Thanks
I am new on the forum and was wondering if someone could help me.
I have a set of data, imports and exports every year from 2000 to 2013.
as follows
year exports imports
2000 269.6 287.8
2001 277.7 301.1
2002 293.1 319.0
2003 305.8 338.8
and so on
I am asked to rebase the year 2010 at 100 for both exports and imports. Could you please help me figure out how to do that in excel.
Thanks