find minimum from cell array
2 views (last 30 days)
Show older comments
Find the minimum from the column named COL2 in the excel and get its corresponding value from COL1 for each M1, M2 and M3
0 Comments
Accepted Answer
KSSV
on 20 Oct 2021
Edited: KSSV
on 20 Oct 2021
T = readtable('my_excel.xlsx') ;
[val,idx] = min(T.(2)) ; % get minimum from col2
iwant = T.(1)(idx) ; % get the value
If you proceed with xlsread which is outdated:
[num, txt, raw] = xlsread('my_excel.xlsx') ;
[val,idx] = min(num(:,2));
iwant = num(idx,1)
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB 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!