Sort rows or cells (descending first column) where second column has repeated value

I have a set of points (x, y) in a matrix and want to re-arrange them according to a criteria.
Original : x ----- y (dots showing rows to arrange)
162, 59
161, 60
. 159, 61
. 160, 61
158, 62
157, 63
. 155, 64
. 156, 64
. 157, 64
. 153, 65
. 154, 65
152, 66
I need to sort them by row (descending within column 1, x) where my column 2 (y) has a repeated value.
Arranged: x ----- y
162, 59
161, 60
. 160, 61
. 159, 61
158, 62
157, 63
. 157, 64
. 156, 64
. 155, 64
. 154, 65
. 153, 65
152, 66
Since column 2 always has the same value within the criteria, I should sort only the column 1 (always within the criteria, of course).
Preferably without using loops. I am looking for the correct MATLAB way of doing it.

 Accepted Answer

Use sortrows
B=flipud(sortrows(A,1))

6 Comments

The second option actually works better, since the first option changes some column 2 order at the beginning and end.
Sorry! I am obviously not thinking straight. Since it will be the same thing as in my original.

Sign in to comment.

More Answers (0)

Categories

Products

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!