Rebase to 100 in excel

[bmetera]

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

 

[Andrew Poulsom]

Welcome to MrExcel.

To do that you would need some sort of index for each year, inflation for example.

 

[Oeldere]

Maybe like this:

Book1
	A	B	C	D	E
1	year	exports	imports	New exp	New inp
2	2000	269,60	287,80	77,03	82,23
3	2001	277,70	301,10	79,34	86,03
4	2002	293,10	319,00	83,74	91,14
5	2003	305,80	338,80	87,37	96,80
6	2010	350,00	350,00	100,00	100,00
Blad1

Cell Formulas
Range	Formula
D2	=B2/$B$6*100
D3	=B3/$B$6*100
D4	=B4/$B$6*100
D5	=B5/$B$6*100
D6	=B6/$B$6*100
E2	=C2/$C$6*100
E3	=C3/$C$6*100
E4	=C4/$C$6*100
E5	=C5/$C$6*100
E6	=C6/$C$6*100