MATLAB: Find matched data (place of equal values)

find place of equal valuesmatch data

how i can find matched cells in two columns with accept multi matches for any cell.
the data is:
i use this code:
for j=1:length(defs)     
     querymdr=data2(:,1);       # quermdr 5*1 cells  
   y=alldata(:,1);              % y 37*1 cells      
      ind=find(y==querymdr) ;  
    record= alldata(idx,:);
%  record=[alldata{idx(1),:}];  
   for k=2:length(idx)
       record = [record,(alldata(idx(k),6))];
   end
   data1(j,:)=record;% put combined record into result table
   end
it gives me an error in
 ind= find(y==querymdr) ;
with a message "Undefined function 'eq' for input arguments of type 'cell'. " what i can do ?
any help please…!

Best Answer

a1 = cat(1,querymdr{:});
a2 = cat(1,alldata{:,1});
ii = ismember(a2,a1);
record = [alldata{ii,6}];
Related Question