MATLAB: Getting unique values of an excel sheet relying on one column only.

excelMATLAB

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.

Best Answer

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,:);
Related Question