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

2 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)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!