Math within an array
Hi! is there somebody that can help me with a VBA code for excel? Thanks in advance.
I have one column A with 100 values
Base=A(1)
i=i+1
B(i)=A(i)/Base Until B(i)>=1.1 Then Base=A(i)
Example
A B C First Base= 12
12
12.5 1.042 1
14.5 1.21 1,21 Second Base= 14,5
15 1.034 1
16 1.103 1.103 Third Base= 16
This procedure until I reach the last row occupied.
Best regards Alfredo
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago