Extracting data in a range

Hello all,

Suppose I have the following matrix 'A':

[0.1, 2, 83, 1000;

0.4, 3, 79, 1001;

0.2, 4, 91, 1018;

0.3, 5, 75, 1095]

And I want to extract a matrix B, from matrix A where the value of element of third coulum is between 70 and 80. So Matrix B would be:

[0.4, 3, 79, 1001;

0.3, 5, 75, 1095]

Thanks!

Answer 1

[Star Strider]

Try this —

format short g
A = [0.1, 2, 83, 1000; 
     0.4, 3, 79, 1001; 
     0.2, 4, 91, 1018;
     0.3, 5, 75, 1095];

B = A(A(:,3)>=70 & A(:,3)<=80,:)

B = 2×4

0.4 3 79 1001 0.3 5 75 1095

It creates a logical vector to address the appropriate rows, then copies all the respective columns to ‘B’.

.

[Asif Rashid]

Thanks. Appreciate it.

[Star Strider]

As always, my pleasure!