How to extract data in excel file in matlab

 Accepted Answer

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.

Categories

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!