MATLAB: How to get data based on first and second column

data

Hallo, I have matrix (793576×3) that consist of x,y,z, which are x = longitude and y = latitude and z = depth.
I want to get z data only for coordinate x,y (92,8.25),(92.5,8.0).., and so on that means +0.25 for x coordinate and -25 for y coordinate. so the results should be
x y z
92 8.25 –
92.25 8.0 –
92.50 7.75 –

Best Answer

mxx=max(A(:,1));                     % max X coordinate in array
ix=ismember(A(:,1),[92:0.025:mxx]);  % locations in A of desired values
B=A(ix,:):                           % those elements of A
Related Question