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

조회 수: 3(최근 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개)

Community Treasure Hunt

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

Start Hunting!

Translated by