Use info in the row based on it being the max value

I have an excel sheet with info that i turned into a matrix, there is info on year, distance, diameter, energy etc.

I did determine the biggest object in diameter using max(), now based on the location of that cell in need to use the info in that ROW without hardcoding. How do I chain index the row based on the max value in the column from previous condition? See code below..

neos = readmatrix('neosData.xlsx');

mat = neos

diameter = mat(:,7);

maxDiameter = max(diameter);

Answer 1

[Stephen23]

The second output from MAX is the index, you can use that:

[maxDiameter,idx] = max(diameter);
row = mat(idx,:)