MATLAB Answers

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

4 views (last 30 days)
pranati pradhan
pranati pradhan on 21 Nov 2019
Answered: Bob Nbob on 21 Nov 2019
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.

  0 Comments

Sign in to comment.

Accepted Answer

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

  0 Comments

Sign in to comment.

More Answers (0)