how can i search for largest negative value in a column in a matrix and return values in the corresponding row

Hi I have a table with columns latitude, longitude and shear wave anomaly. I want to search for the largest shear wave anomaly and return the corresponding latitude and longitude. how would i go about this?

cheers alex

Answer 1

[Azzi Abdelmalek]

[max_val,idx]=max(A(:,3))
lat=A(idx,1)  % corresponding latitude
long=A(idx,2)  % corresponding longitude