Skip to main content
P
ptc-51055451-Visitor
1-Visitor
July 11, 2013
Solved

Need help turning a range into a matrix

  • July 11, 2013
  • 2 replies
  • 1425 views

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.

Best answer by RichardJ

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

2 replies

R
RichardJ19-TanzaniteAnswer
19-Tanzanite
July 11, 2013

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

P
ptc-51055451-VisitorAuthor
1-Visitor
July 11, 2013

Thanks

W
Werner_E25-Diamond I
25-Diamond I
July 11, 2013

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

Terms & ConditionsAccessibility statement