find minimum from cell array

2 次查看（过去 30 天）

Elysi Cochin 2021-10-20

编辑： Elysi Cochin 2021-10-25

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 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)

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by