M
Mike Perchoir
Hello
I have the following data
Année V1 V2 V3 National
1992 14805 100
1993 16521 2640 120
1994 17839 2142 117
1995 19878 1236 1207 136
1996 12456 1024 140
1997 14526 1563 1274 152
I want to calculate an "'indice" with vba or a formula
example: to obtain these news values
Année V1 V2
V3 National
1992 (14805 *100)/14805
100
1993 (16521*100)/14805
(2640*120)/2640 120
1994 17839 *100)/14805 (2142*117)/2142
117
1995 19878 *100)/14805 (1236*117)/2142
(1207*120)/2640 136
1996 12456 *100)/14805 (1024 *117)/2142
140
1997 14526 *100)/14805 (1563 *117)/2142
(1274*120)/2640 152
How do?
Excel version xp/2003
Mike
Excuse my english
I have the following data
Année V1 V2 V3 National
1992 14805 100
1993 16521 2640 120
1994 17839 2142 117
1995 19878 1236 1207 136
1996 12456 1024 140
1997 14526 1563 1274 152
I want to calculate an "'indice" with vba or a formula
example: to obtain these news values
Année V1 V2
V3 National
1992 (14805 *100)/14805
100
1993 (16521*100)/14805
(2640*120)/2640 120
1994 17839 *100)/14805 (2142*117)/2142
117
1995 19878 *100)/14805 (1236*117)/2142
(1207*120)/2640 136
1996 12456 *100)/14805 (1024 *117)/2142
140
1997 14526 *100)/14805 (1563 *117)/2142
(1274*120)/2640 152
How do?
Excel version xp/2003
Mike
Excuse my english