How to select cells in a table with values in a given range?

3 views (last 30 days)
E.g. I want to select every cell from a column whose content is a number in the range 1:2:17.
  3 Comments
Bob Thompson
Bob Thompson on 29 Mar 2018
Are you looking to do this selection in matlab, or in excel directly?
Elissa
Elissa on 29 Mar 2018
Shounak Shastri - yes I want to select the cells that contain a value in the range 1 to 17 in steps of 2.
Bob Noob - I want to do this in matlab on a matlab table.

Sign in to comment.

Accepted Answer

Peter Perkins
Peter Perkins on 29 Mar 2018
Hard to say what you are really asking, but in MATLAB ...
t = readtable(example.xls')
t2 = t(ismember(t.condition,1:2:17),:)

More Answers (0)

Community Treasure Hunt

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

Start Hunting!