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

Community Tip - You can change your system assigned username to something more personal in your community settings. 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.

1 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

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

Top Tags