Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write formula with code ...
Hi There,
Starting Cell = A20 (GBSUP) Number of items = Variable but Starting at $B$21 ...B65000 Number of Periods = Variable C19 ...20 ...21 .... DEC1403 DEC1204 DEC1105 ..... GBSUP WHITE B.I.B1 1,9 1,8 2,1 WHITE B.I.B2 4,6 4 4,6 WHITE B.I.B3 4,1 4,4 5,3 WHITE B.I.B4 0 0 0 WHITE B.I.B5 0 0 0 ..... I would like to write via code a formula that multiplies my %shares (the figures above) with my totals which I calculate as follows: =INDEX(SOURCE;MATCH($A$20;INDEX(SOURCE;;1);0);MATC H(C$19;INDEX(SOURCE;1;0);0)) In this example I would copy down and 3 cells to the right in F21: =OFFSET($A$20;ROW()-20;COLUMN()-COUNTA($19:$19)-1;1;1)*INDEX(SOURCE;MATCH($A$20;INDEX(SOURCE;;1);0 );MATCH(C$19;INDEX(SOURCE;1;0);0)) The problem is that my starting point to plug this formula in varies: It depends on the number of periods chosen (in row 19) (and the number of items down). Hope you understand, Could you help me out please? Best Regards Sige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
could someone write me a VB code? thanks | New Users to Excel | |||
Write code to Write Code | Excel Programming | |||
Code to write out all lines of code | Excel Programming | |||
How do I write a formula to color code based on dates provided or. | Excel Worksheet Functions | |||
How can i write TSR code | Excel Programming |