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

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.

Answer 1

[Andrei Bobrov]

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

[ND]

Many thanks