Sort rows or cells (descending first column) where second column has repeated value
1 view (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
Azzi Abdelmalek
on 5 Mar 2013
Edited: Azzi Abdelmalek
on 5 Mar 2013
Use sortrows
B=flipud(sortrows(A,1))
6 Comments
More Answers (0)
See Also
Categories
Find more on Shifting and Sorting Matrices in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!