How to remove duplicates in matrix with condition

1 view (last 30 days)
Hi everyone,
I just want to remove duplicates from NX2 matrices according to greatest value from column 2. for instance lets say we have 5x2 matrices;
X = [1 10;2 20;3 30;3 31;3 32]
at the result ı want to find
Xresult = [1 10;2 20;3 32]
So, I want to eliminate duplicates in "3" values and I want to see greatest "3" value in order to interpret my work.
Regards,

Accepted Answer

Bruno Luong
Bruno Luong on 6 Oct 2019
X = [1 10;2 20;3 30;3 31;3 32];
Xs=sortrows(X);
[~,I]=unique(Xs(:,1),'last');
XResult = Xs(I,:)

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!