In this file first column is r, second is c, fourth is R,fifth is C.. I want to find and save all those R,C which are same as r,c.. R,C are pairs and when matching is to do R,C will be compared to r,c..
data=xlsread('Book1.xlsx'); r=data(~isnan(data(:,1)),1); c=data(~isnan(data(:,2)),2); R=data(~isnan(data(:,4)),4); C=data(~isnan(data(:,5)),5);
[flag,index] = ismember([r c],[R C],'rows'); RR = R(index(flag)); CC = C(index(flag)); plot(r,c,'r.',R,C,'g.',RR,CC,'b.');
Play games and win prizes!Learn more