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

Need help turning a range into a matrix

ptc-5105545
1-Newbie

Need help turning a range into a matrix

I have a range, but I need to turn it into a vector in order to be able to work with is. Can this be done? I have attached a sheet with an example.

ACCEPTED SOLUTION

Accepted Solutions
RichardJ
19-Tanzanite
(To:ptc-5105545)

There are several versons of this function floating around. This is my preferred version.

View solution in original post

3 REPLIES 3
RichardJ
19-Tanzanite
(To:ptc-5105545)

There are several versons of this function floating around. This is my preferred version.

Thanks

Werner_E
25-Diamond I
(To:ptc-5105545)

Here are some similar routines to turn a range into a vector or to create a vector on the fly by given first, second and last value for your convenience.

range2vect.png

Announcements

Top Tags