find minimum from cell array
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
KSSV
il 20 Ott 2021
Modificato: KSSV
il 20 Ott 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!