Find rows in which the first column is within a range defined by a value in another matrix.

I am extracting rows from matrix acc1, which have a first column value within a certain range . This range is defined by two values taken from a double, a. I am getting error messages for this and not sure why.

q=acc1(acc1(:,1) > a(1,1) & acc1(:,1)< a(2,1) , :);

[Voss]

That line looks like it'll do what you describe.

acc1 = randi(10,5,2);
a = [3; 7];

q=acc1(acc1(:,1) > a(1,1) & acc1(:,1)< a(2,1) , :);

disp(acc1);

     5     6
     8     8
    10     9
     4     3
     5     6

disp(q);

     5     6
     4     3
     5     6

So what error messages do you get?

[Nicolaas Pickard]

Operator '>' is not supported for operands of type 'cell'.

How do I stop something being a cell? I used readcell to import data from an excel sheet, is there a better alternative? I would use readmatrix but matlab was saying that is now not reccomended.

[Voss]

As far as I know readmatrix is still recommended. Try that and see if the returned variable(s) is/are as you expect.

[Nicolaas Pickard]

Yeah it worked perfectly. Thanks :)

[Voss]

You're welcome!