How to extract data in excel file in matlab

 Accepted Answer

David
David on 17 Feb 2020
Thanks you so much for your help. Is that ind is the function code or something that i named before?

More Answers (1)

data = readmatrix('2014-2015 KU Basketball.xlsx');
[val, ind] = max(data(:, 2));
game_num = data(ind, 1);

3 Comments

Thanks you so much for your help. Is that ind is the function code or something that i named before?
ind is index of the maximum value in column 2. read https://in.mathworks.com/help/matlab/ref/max.html
Oh i got it. Thanks you so much. It is really helpful

Sign in to comment.

Tags

Asked:

on 17 Feb 2020

Edited:

on 24 Feb 2020

Community Treasure Hunt

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

Start Hunting!