Skip to main content
D
DickCun1-Visitor
1-Visitor
June 23, 2014
Solved

Change values in columns in an array so that they are in ascending order

  • June 23, 2014
  • 6 replies
  • 3150 views

Convert the values in the following matrix:

 

 

so that they are in ascending order thusly:

 

 

Thanks for anyhelp provided!

 

Dick.....

Best answer by DickCun

Thanks all for your help!!!!

6 replies

V
24-Ruby IV
ValeryOchkov24-Ruby IV
24-Ruby IV
June 23, 2014

See please the csort function.

M
MikeArmstrong1-Visitor
1-Visitor
June 23, 2014

I cannot see the images you have uploaded please upload worksheet.

W
Werner_E25-Diamond I
25-Diamond I
June 23, 2014

Images cannot be inserted in the context of a post via cut and paste - it only looks OK until you add the reply! You have to use the appropriate button to insert images.

To attach files you have to chose "Use advanced editor" at the upper right.

Have you looked up in the help the various sort commands? (sort, csort, rsort)

D
DickCun1-VisitorAuthor
1-Visitor
June 23, 2014

Sorry about images not showing up......

Here is the worksheet I have been using to resolve this issue......

Dick.......

V
24-Ruby IV
ValeryOchkov24-Ruby IV
24-Ruby IV
June 23, 2014

My variant:

Matrix+Values+Ascending+Order-Val.png

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
June 23, 2014

column by column

D
DickCun1-VisitorAuthorAnswer
1-Visitor
June 23, 2014

Thanks all for your help!!!!

Terms & ConditionsAccessibility statement