removing an entire row

Hi,

I have array where in column 3 contains names, see attached image. I want to remove the row that is not duplicated in other words has different name, for example grace in the image. The logic approach I want to use to is: if all rows in column 3 are not equal to "fred", then remove that row.

I've tried this approach below, but no success.

a=test(:,3)~=x

if isempty(a)==1

test(find(a==1),:)=[];

end

Note: x="fred" and test is the array

Thank for your help.

Answer 1

[Sean de Wolski]

grace = s(s(:,3)~="fred",:)

[Daneisha Blair]

Thank you Sean, this located the row that contains grace. Now, how can I remove the row (grace) from the s array?