find dublicated value in a column and return the whole row

1 view (last 30 days)
imagine I have this:
A = [ 1 ; 3 ; 5 ; 6 ; 9 ]
and
B = [ 1 4 ; 2 7 ; 3 5 ; 9 10 ]
I need to end up with:
C = [ 1 4 ; 3 5 ; 9 10 ]
In B(:,1) column I need to find those from A that match, and if so, return the full rows of B. Hope I am clear

Accepted Answer

madhan ravi
madhan ravi on 22 Oct 2018
A = [ 1 ; 3 ; 5 ; 6 ; 9 ]
B = [ 1 4 ; 2 7 ; 3 5 ; 9 10 ]
idx=ismember(B(:,1),A)
C = B(idx,:)

More Answers (0)

Categories

Find more on MATLAB in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!