Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hell
i've the following data Année V1 V2 V3 Nationa 1992 14805 10 1993 16521 2640 120 1994 17839 2142 117 1995 19878 1236 1207 136 1996 12456 1024 14 1997 14526 1563 1274 15 jI want to calculate an "'indice" with vba example: to obtain these news value Année V1 V2 V3 Nationa 1992 (14805 *100)/14805 10 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 14 1997 14526 *100)/14805 (1563 *117)/2142 (1274*120)/2640 15 How do Excel version xp/200 Mik Excuse my english |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |