find a rows in matrix and its position in that matrix ?

datasheet(48*6)size
%I had a matrix of size(48*6) and then
ii = randperm(size(datasheet,1));
k = ones(24,1)*2;
out = mat2cell(datasheet(ii(1:sum(k)),:),k,size(datasheet,2));
%then i select a row from datasheet lets say 4th row
B=datasheet(4,:);
%now I want to find out the position of that 4th row in "out" matrix.

 Accepted Answer

out{ ceil( find(ii == 4)/2 ) }

3 Comments

I want to know B position in out matrix, at which rows it exists?
Row ceil( find(ii == 4)/2 )
If I have updated K and datasheet values like attached file then I did not find according to this code and I also tried Index/find but did not get

Sign in to comment.

More Answers (1)

In general case:
[~,ji] = cellfun(@(x)ismember(B,x,'rows'),out,'un',0);
jj_cell = find(cellfun(@(x)x>0,ji));
ii_row_in_cell = ji{jj_cell};

Categories

Community Treasure Hunt

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

Start Hunting!