cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Array index for sequences

MS_10464889
2-Explorer

Array index for sequences

Hello, how should i properly set array index, so that my sequence is calculated? 

ACCEPTED SOLUTION

Accepted Solutions
Werner_E
25-Diamond I
(To:Werner_E)

In case you insist on doing the calcs on worksheet level using a range variable, here are two ways:

1)

Werner_E_1-1666457511143.png

 

2)

Werner_E_2-1666457545516.png

 

 

View solution in original post

6 REPLIES 6
Werner_E
25-Diamond I
(To:MS_10464889)

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

Werner_E
25-Diamond I
(To:MS_10464889)

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

Werner_E_0-1666457318423.png

 

Werner_E
25-Diamond I
(To:Werner_E)

In case you insist on doing the calcs on worksheet level using a range variable, here are two ways:

1)

Werner_E_1-1666457511143.png

 

2)

Werner_E_2-1666457545516.png

 

 

Thank you very much, Have a great day!

problem2.png

unfortunately i came across a new problem, even tho it seems to be a carbon copy of your solution...

Announcements

Top Tags