Sort Data by Second Column

66 views (last 30 days)
Brian Robinson
Brian Robinson on 26 May 2020
Answered: Brian Robinson on 26 May 2020
Hello there,
I have data witht the first column being the year and the second column being the rainfall. I would like to sort the data from largest rainfall to smallest while keeping the associated years the same. I have tried using the Sort function of exactly how to do this.
Any help is appreciated,
Thanks,
Brian

Accepted Answer

Stephen23
Stephen23 on 26 May 2020
Edited: Stephen23 on 26 May 2020
Use sortrows, e.g. where M is your matrix:
M = sortrows(M,2);
If you really want to use sort, then of course you will need to use indexing, e.g.:
[~,idx] = sort(M(:,2));
M = M(idx,:);

More Answers (1)

Brian Robinson
Brian Robinson on 26 May 2020
Thanks Stephen.

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!