match row and column

6 views (last 30 days)
Tanmoyee Bhattacharya
Tanmoyee Bhattacharya on 25 Feb 2016
Edited: Stephen23 on 25 Feb 2016
I have one matrix
a=
1 3 0
2 5 0
3 7 0
4 8 0
5 10 0
and another is
b=
5 10
3 7
I want to do find(a(:,1)=b(:,1) & a(:,2)==b(:,2) so that
5 10 0
3 7 0

Accepted Answer

Stephen23
Stephen23 on 25 Feb 2016
Edited: Stephen23 on 25 Feb 2016
You can use ismember to generate the logical indices. In the same order as a:
>> idx = ismember(a(:,1:2),b,'rows');
>> a(idx,:)
ans =
3 7 0
5 10 0
Or in the same order as b:
>> [~,idx] = ismember(b,a(:,1:2),'rows');
>> a(idx,:)
ans =
5 10 0
3 7 0

More Answers (0)

Categories

Find more on Cell Arrays in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!