MATLAB: Delete row based on criteria of 2 variables

Question

In matrix A, I have n X 6 columns. In matrix B, I have n X 1 column. What I want to do is, if the element in column 6 of matrix A is larger than the element in column 1 of matrix B (i.e. A(:,6) > B(:,1)), then delete the row. Both matrices are of type double. What is the best way to script this?

I tried this:

for i = 1:n
if A(i, 6) > B(i, 1);
    A(i,:) = [];
end
end

But it was quite slow (i have approx. 400,000 x 30 rows of data). Any other ways?

Answer 1

A( A(:,6) > B, : ) = [];