find a row with a column value don't remove duplicated cells
2 次查看(过去 30 天)
显示 更早的评论
i compare data in two sheets, if there are a dublicated row i want to save its last cell column in the previous row i use for i=1:size(alldata,1) for j=1:length(defs)
if data2{j,1}==alldata{i,1} % compare MDR in two files, if equal
data1(j,:)=alldata(i,:); % put all data of text in array(data1)
if data1{j-1,1} == data1{j,1} % here it gives me error
data1(j,C2+1)=alldata(i,6); % put dyplicated text in C7 works good
end
end
end
end
but it gives me error in
" if data1{j-1,1} == data1{j,1}"
how i can solve this ?
0 个评论
采纳的回答
Nobel Mondal
2015-5-12
编辑:Nobel Mondal
2015-5-12
for j=1, it is trying to access data1{0,1} but matlab indexing starts from 1.
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!