Clear Filters
Clear Filters

find rows with specific value

1 view (last 30 days)
Amr Hashem
Amr Hashem on 12 May 2015
Answered: Sean de Wolski on 12 May 2015
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 ?

Answers (1)

Sean de Wolski
Sean de Wolski on 12 May 2015
doc ismember
doc intersect

Community Treasure Hunt

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

Start Hunting!