Hello,
How do I count the number of #N/A values in a downloaded CSV or Excel?
Unfortunately, expected functions like =ISNA are not working matching?
Thank you.
LV
Best answer by john.desborough
View originalHello,
How do I count the number of #N/A values in a downloaded CSV or Excel?
Unfortunately, expected functions like =ISNA are not working matching?
Thank you.
LV
Best answer by john.desborough
View original
des
Looks to be some weird problem when downloading in excel format versus CSV format. in excel, the field category is ‘text’ whereas in csv, the field category is ‘general’.
In CSV, using formulas like =COUNTIF(A1:A100,NA()) and =ISNA do in fact work.
But in excel format, they do not.
Hope this helps others.
this article here says the same thing..
check to see if that works
des
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.