find minimum from cell array

Find the minimum from the column named COL2 in the excel and get its corresponding value from COL1 for each M1, M2 and M3

 采纳的回答

KSSV
KSSV 2021-10-20
编辑:KSSV 2021-10-20
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 个)

类别

标签

Community Treasure Hunt

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

Start Hunting!

Translated by