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

Need help turning a range into a matrix

  • July 11, 2013
  • 3 replies
  • 1444 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.

3 replies

RichardJ19-TanzaniteAnswer
19-Tanzanite
July 11, 2013

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

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

Thanks

Werner_E
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