find rows with specific value

1 次查看(过去 30 天)
Amr Hashem
Amr Hashem 2015-5-12
i have two excel sheets(a,b), and want to compare a(:,1) with b(:,1) and if equal show a&b
a & b sheets are:
i try: j=1; for i=1:size(alldata2,1) if isequal(alldata2{i,26},'MKJ') defs(j)=i; j=j+1; end end data2=alldata2(defs,:); % Failures of defibrillator
rowsize=length(defs);
data1=cell([rowsize,C2]); % create array with size [R,C]
for i=1:size(alldata,1)
for j=1:length(defs)
if data2{j,1}==alldata{i,1} % i think here is the problem
data1(j,:)=alldata(i,:) % put all data of text in array(data1)
end
end
end
defib_data_2002=[data2,data1]; % show device & text data
the code works good
but it remove the duplicated rows in file b
and i want all the data
how i can save all rows included the duplicated ones ?

回答(1 个)

Sean de Wolski
Sean de Wolski 2015-5-12
doc ismember
doc intersect

Community Treasure Hunt

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

Start Hunting!

Translated by