Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hello, how should i properly set array index, so that my sequence is calculated?
Solved! Go to Solution.
In case you insist on doing the calcs on worksheet level using a range variable, here are two ways:
1)
2)
There may be easier ways to generate vectors with alternating Fibonacci numbers 😉
Is it a typo that you used index j*1 instead of just j or did you mean j-1?
its not meant to be fibonacci numbers, its just something random to test how sequences work here. I dont know how to get around K and D sequences not being initialized at the same time
This does not answer my question if your j*1 just means j or if you wanted to type j-1
A assume the first and would suggest using a generating function to do the job
In case you insist on doing the calcs on worksheet level using a range variable, here are two ways:
1)
2)
Thank you very much, Have a great day!
unfortunately i came across a new problem, even tho it seems to be a carbon copy of your solution...