MATLAB: How to store values of rows in a matrix where the 3rd column is a multiple of 100

Question

I have a matrix with 3 columns and a large number of rows. In order to reduce the rows, I need to keep the rows whose 3rd column value is a multiple of 100 and store it in as a new matrix. How do I do that?

Answer 1

Use can use rem() to filter the rows where the third column is multiple of 100 and then use logical indexing

M; % nx3 matrix
idx = rem(M(:,3),100)==0;
M_new = M(idx, :);