Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone knows how to check if the fields in a column is '#N/A'? i have tried some methods such as:
if(not(left("ColumnName",1) = Chr(35)
if(not(SubField("ColumnName",'N',1) = Chr(35)
but nothing seems to work and i'm not sure why. It would only work if i find and replace every fields that are '#N/A' to '#NA' in the excel sheet
I have advised someone else on the topic in this thread: Help with reading Excel #Ref
Even though the title of the thread only refers to #REF it also includes #N/A values in the suggested solution.