I want to extract values from second column of the matrix which correspond to the range 6 to 7 of the first column. How to do it?

21 views (last 30 days)
I have a 2 column matrix. Each column contains around 4 million elements (numbers). I have sorted the matrix with respect to increasing order of the first column. I want to extract the values from the second column which are corresponding to values between 6 and 7 of the first column. How to do it ?

Accepted Answer

Turlough Hughes
Turlough Hughes on 8 Mar 2020
Let's say your matrix is called M, then you can extract rows from column 2 corresponding to those in column 1 which are between 6 and 7 as follows:
result = M(M(:,1)<=7 & M(:,1)>=6,2);
You can also see the output from both columns to confirm that it is correct:
M(M(:,1)<=7 & M(:,1)>=6,:)

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!