清空筛选条件
清空筛选条件

How can I filter excel's data which the data that i want only have value larger than 80 only?

1 次查看（过去 30 天）
shazwani amran
shazwani amran 2013-3-26
the data was like this in excel:
RT 1.1 2.2 3.3 4.4
Area 12 13 14 15
*Qual 40 89 39 90
i want to filter the data to become:
RT 2.2 4.4
Area 13 15
*Qual 89 90

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2013-3-26
[num, txt] = xlsread('YourFile.xls');
num(:, num(:,3) <= 80) = [];

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by