How to find the given index values in a array?

I have a matrix having 17 rows and 41 colums (find the attachment)
How to find the values at the top from 2nd column to last column with respect to the first column corresponing values

 Accepted Answer

in R2016b
T = readtable('Sheet2.xls','ReadVariableNames',0);
lo = T{:,2:end} ~= 0 & ~isnan(T{:,2:end});
[ii,~] = find(lo);
out = sortrows([T{:,2:end}(lo),T{:,1}(ii)],2);

2 Comments

Thank you very much
sir
pls send me your mail id

Sign in to comment.

More Answers (0)

Categories

Tags

Asked:

on 25 Apr 2019

Commented:

on 25 Apr 2019

Community Treasure Hunt

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

Start Hunting!