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?

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?

Answer 1

[Cam Salzberger]

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

[Debbie Oomen]

Thank you. Now how can I display all the values of that column? I can now only see the column number

Answer 2

[KL]

data = xlsread('yourfile.xls');
maxVal = max(data);
[mmaxVal col_no] = max(maxVal)

[Debbie Oomen]

Thank you. I can see the column number but how can I display the entire column with all its values?

[KL]

data(:,col_no)

should display that column.