MATLAB: Indexing cell array similar to excell

Question

Hello,

I have a 177×25 matrix, which has been imported from excel. I am trying to filter it based on the different variables. The one I am struggling with is the following:

I have a 1*177 cell variable, this has 2 different names, 'A 123' and 'B 456'. I want to filter them separately and use each of them to filter the rest of the data. Any help, thanks

Answer 1

Maybe like this:

Data  = rand(7, 25);  % Example data, actually 177x25
Names = {'A 123', 'A 123', 'B 456', 'A 123', 'B 456', 'B456', 'A 123'};
A123 = strcmp(Names, 'A123');
B456 = ~A123;
Set1 = Data(A123, :)
Set2 = Data(B456, :)