MATLAB: How to take value of particular interval from a column

matrix

there is column having arbitrary value from 0-1200 but I have to take only 600-800 from that column? How can I ?
1100    4.7693  13.746  0.08116  308.6983
1160    4.5938  13.24  0.08112  308.68619
1220    4.5577  13.136  0.08109  308.67407
1280    4.9122  14.158  0.08105  308.66205
1340    5.0029  14.419  0.08102  308.64944
1400    4.7408  13.664  0.08099  308.63684
20    4.7447  13.675  0.08096  308.62524
80    4.8635  14.017  0.08093  308.61322
140    4.7867  13.796  0.0809  308.60065
200    4.6726  13.467  0.08088  308.58905
260    4.7121  13.581  0.08086  308.57675
320    4.6942  13.529  0.08083  308.56442
a=xlsread('Book1.xlsx');
k=1;
for i=1:length(a(:,1))
if 600<=a(i,1)>=800
a(i,1)=NaN;
k=k+1;
end
end

Best Answer

a(a(:,1)>800 & a(:,1)<1000,1)=nan
Related Question