I imported data from a large excel file and now I want to delete the rows that have the values of column "dds" equal to 1 or 7. How can I proceed?

I imported data from a large excel file and now I want to delete the rows that have the values of column "dds" equal to 1 or 7. How can I proceed?

Answer 1

[Walter Roberson]

ddscol = 4;   %set according to which column it is in
YourData( ismember(YourData(:,ddscol), [1, 7]), :) = [];   %delete the rows where dds is 1 or 7

[Eduardo Rocha]

Already found another way but thank you anyway, that should work as well :)