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}
data1(j,:)=alldata(i,:)
end
end
end
defib_data_2002=[data2,data1];
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 ?