Finding Rest of Row
3 views (last 30 days)
Show older comments
Anjali Parmar
on 19 Feb 2020
Commented: Anjali Parmar
on 19 Feb 2020
Hello! Matlab newbie here. So I have a bunch of data in rows/columns. If I have a variable assigned to something in a specific row in column 1, how do I find the values in the rest of the row in the rest of the columns (there's like five total)? I appreciate any help!
0 Comments
Accepted Answer
Gifari Zulkarnaen
on 19 Feb 2020
Do you mean like vlookup in excel? Try this:
data = randi(1,4,5); % Just an example matrix
first = data(randi(4),1); % Example of desired number in first column
index = data(:,1) == first; % Find in which row is your desired number located
rest = data(index,2:end); % Get the rest of columns of that row
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!