Getting unique values of an excel sheet relying on one column only.
1 view (last 30 days)
Show older comments
Please, I have an excel file with many rows and five columns. I need to remove the duplicated data of all columns considering the uniqueness of the last column only.
For example:( x,y,z,p,f) are columns
x y z p f
1 2 3 4 5
1 3 5 6 4
2 3 5 7 4
3 4 1 5 4
the result should be
1 2 3 4 5
1 3 5 6 4
Many thanks for help.
0 Comments
Accepted Answer
Andrei Bobrov
on 4 Sep 2016
z = [1 2 3 4 5
1 3 5 6 4
2 3 5 7 4
3 4 1 5 4];
[~,b] = unique(z(:,end),'stable');
out = z(b,:);
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB 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!