how to calculate how many rows are having numeric values in a particular cell of an excel sheet data.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
pranati pradhan
le 21 Nov 2019
Réponse apportée : Bob Thompson
le 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 commentaires
Réponse acceptée
Bob Thompson
le 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!