Search for an element in cell array?

15 views (last 30 days)
So I have a dataset as follows
NaN 51.1512 4.0000 6.0000
NaN 80.7646 3.0000 6.0000
NaN 89.3755 2.0000 6.0000
NaN 96.3119 1.0000 6.0000
NaN 51.1512 8.0000 5.0000
NaN 80.7646 7.0000 5.0000
5.1104 89.3755 6.0000 5.0000
NaN 96.3119 5.0000 5.0000
9.0177 51.1512 12.0000 4.0000
NaN 80.7646 11.0000 4.0000
5.3294 89.3755 10.0000 4.0000
now, I want the element in row 3, for a value of say 5 from row 4 and a value of 89.3755 of row 2, which is 6.0000.
Can you tell me how to do that? Thanks!
  1 Comment
Azzi Abdelmalek
Azzi Abdelmalek on 24 Jun 2016
I am not sure, but I think you are confusing rows and columns, which makes your question not clear

Sign in to comment.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 24 Jun 2016
Edited: Azzi Abdelmalek on 24 Jun 2016
A=[NaN 51.1512 4.0000 6.0000
NaN 80.7646 3.0000 6.0000
NaN 89.3755 2.0000 6.0000
NaN 96.3119 1.0000 6.0000
NaN 51.1512 8.0000 5.0000
NaN 80.7646 7.0000 5.0000
5.1104 89.3755 6.0000 5.0000
NaN 96.3119 5.0000 5.0000
9.0177 51.1512 12.0000 4.0000
NaN 80.7646 11.0000 4.0000
5.3294 89.3755 10.0000 4.0000]
idx=find(ismember(A(:,2),89.3755)&ismember(A(:,4),6))
out=A(idx,:)

More Answers (0)

Community Treasure Hunt

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

Start Hunting!