Hi everyone !
For my first post, i thought of asking a stupid question. . Here we go :
I have excel file a bit like that but with random numbers going from 1 to 500000
<tbody>
</tbody>
The cells in row two are multiplied with the cells in row 1 beginning with the first cell in row and added to the value of the multiplication of the previous cells "offset by 1 to the right each time
To give you an idea of the calculation
1* 10 = 10 1st column
(1*20) + (2 *10) = second column
(1*30)+ (2*20) + (3 *10) = third column
(1*40) +(2*30)+ (3*20) + (4*10) = 200 fourth and so on
The problem with using a formula is that i have to manually add some part of the formula each time
For example, in the third column , i was able to generate the first two terms using "offset"but i still need to manually enter the third term...
Now i have turned to writing a vba code but cannot find a way to do it...(i'm quite new with it and i'm a bit bad with using loops)
Can someone give me a push in the right direction?
Cheers
Vjiranashsa
For my first post, i thought of asking a stupid question. . Here we go :
I have excel file a bit like that but with random numbers going from 1 to 500000
10 | 20 | 30 | 40 | 50 | |
1 | 2 | 3 | 4 | 5 | |
10 | 40 | 100 | 200 | 360 |
<tbody>
</tbody>
The cells in row two are multiplied with the cells in row 1 beginning with the first cell in row and added to the value of the multiplication of the previous cells "offset by 1 to the right each time
To give you an idea of the calculation
1* 10 = 10 1st column
(1*20) + (2 *10) = second column
(1*30)+ (2*20) + (3 *10) = third column
(1*40) +(2*30)+ (3*20) + (4*10) = 200 fourth and so on
The problem with using a formula is that i have to manually add some part of the formula each time
For example, in the third column , i was able to generate the first two terms using "offset"but i still need to manually enter the third term...
Now i have turned to writing a vba code but cannot find a way to do it...(i'm quite new with it and i'm a bit bad with using loops)
Can someone give me a push in the right direction?
Cheers
Vjiranashsa