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

1 Ansicht (letzte 30 Tage)
pranati pradhan
pranati pradhan am 21 Nov. 2019
Beantwortet: Bob Thompson am 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.

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Bob Thompson
Bob Thompson am 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)));

Weitere Antworten (0)

Kategorien

Mehr zu Spreadsheets finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by