I have three columns in an excel file and i want MATLAB to find the maximum value from all columns and return the column where the maximum is found. How to do this?

1 次查看（过去 30 天）
Debbie Oomen
Debbie Oomen 2017-10-6
评论： KL 2017-10-8
I have three columns in an excel file and i want MATLAB to find the maximum value from all columns and return the column where the maximum is found. How to do this?

请先登录，再回答此问题。

回答（2 个）

Cam Salzberger
Cam Salzberger 2017-10-6
Hello Debbie,
There are a couple of ways you could do this. One is to use max to find the maximum of each column, and then max on that to find which column:
maxOfCols = max(A);
[~, colIdxOfMax] = max(maxOfCols);
Another would be to just find the linear index of the maximum, then translate out the column index from that:
[~, linIdxOfMax] = max(A(:));
[~, colIdxOfMax] = ind2sub(size(A), linIdxOfMax);
-Cam
KL
KL 2017-10-6
data = xlsread('yourfile.xls');
maxVal = max(data);
[mmaxVal col_no] = max(maxVal)

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by