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

1 visualizzazione (ultimi 30 giorni)
pranati pradhan
pranati pradhan il 21 Nov 2019
Risposto: Bob Thompson il 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.

Accedi per rispondere a questa domanda.

Risposta accettata

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

Più risposte (0)

Categorie

Scopri di più su Spreadsheets in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by