how to calculate how many rows are having numeric values in a particular cell of an excel sheet data.

1 次查看（过去 30 天）
pranati pradhan
pranati pradhan 2019-11-21
回答： Bob Thompson 2019-11-21
I have an excel sheet,there are 9 columns are there.In column no 6,some values are numeric values and some are NaN.So how to calculate how many rows contain numeric values.Please help me with this.

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

采纳的回答

Bob Thompson
Bob Thompson 2019-11-21
Read the file with xlsread, filter the NaN values, then determine the number of the remaining values.
numnumerics = sum(~isnan(data(:,6)));

更多回答（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