Add row to an empty array if a condition is fulfilled

4 views (last 30 days)
Hi everyone,
I have a 5 x 3 array and I have to make a code that checks row by row if the third column fulfills a condition. (In this case, the third column should be equal to the letter "A").
When there's an "A" in the third column, I have to take all that row and place it in a new array and this new array should have all the rows that fulfill the condition.
Edit:
And if I were to do it with a database that I have on Excel, how do I do it?
The column that has the condition that I need is the number 74, that's called "Usar". I tried it with the logical indexing but it showed me nothing.

Accepted Answer

James Tursa
James Tursa on 21 Apr 2021
Edited: James Tursa on 21 Apr 2021
No need for an explicit loop. Just use logical indexing:
result = m(strcmp(m(:,3),'A'),:);

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!