find minimum from cell array

1 view (last 30 days)
Elysi Cochin
Elysi Cochin on 20 Oct 2021
Edited: Elysi Cochin on 25 Oct 2021
Find the minimum from the column named COL2 in the excel and get its corresponding value from COL1 for each M1, M2 and M3

Accepted Answer

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

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!