Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default vba function

Hi
see your other post
-----Original Message-----
Hello
,
i've 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

jI want to calculate an "'indice" with vba.

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


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Data Validation/Lookup function does function correcty Kirkey Excel Worksheet Functions 2 May 25th 09 09:22 PM
copy of excel file not showing formulal/function in the function b oaallam Excel Discussion (Misc queries) 4 September 6th 07 01:20 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton Excel Worksheet Functions 2 May 2nd 05 05:26 PM
User-Defined Function pre-empting Built-in Function? How to undo???? MarWun Excel Programming 1 August 6th 03 09:31 PM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"