How to match #N/A values in csv or excel

@john.desborough do you happen to know this by chance? We all know I’m terrible with spreadsheets. 

@Peter - can you show a screenshot of your spreadsheet and the logic you are trying to use.. that will help me in terms of providing some suggestions ..

@Liz - you’re getting so much better with them though lol..c’mon!!

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.

@Peter - from what i recall you need to use the COUNTIF() function and put “#N/A” in for the criteria - treat it as a text string… 

this article here says the same thing.. 

check to see if that works

des