Indexing cell array similar to excell

Hello,

I have a 177x25 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

[Peter Jarosi]

Could you upload your data and code, please!

[Shinobido]

Hello,

Error_Filt is another variable which is part of teh code

Thanks for replying.

% Error=Target('A 123'); (Errordist_Filt(:)>2.5);

B 567

B 567

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

A 123

Answer 1

[Jan]

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, :)

[Shinobido]

Works just good! Thanks!

[Shinobido]

Finally, I am struglling at creating a new column on after filtering the data.

The code that I have is this, but it creates row and not a column. Could you someone help me on this basic answer? Thanks.

% new_column= [1:height(mastertable)];