Position of a data at Matrix

Hello. I have a matrix 1000*2. Then I found the maximum data in first column. Lets say the maximum is for 500*1. Then I need to get the number in 500*2. How can I find out what is the position of my maximum data please?

Thanks

Answer 1

[Sara]

Given the matrix A

[i,j] = find(A == max(max(A))

[sama]

Thanks. However, I am using my matrix at a for loop. Before that, I am calling my data from an Excel file. So, I am looking for anything to add to my code. I am using the maximum and I wanna call the position the maximum. Do you think find is still a good idea?

for i=1:n-1; sheeti=xlsread('Book1.xlsx',i); A(i)=[min(sheeti(:,2))]; End

[Sara]

What do you want to store in A:

• The minimum value of sheeti
• The position of the minimum value of sheeti