If someone can help improve the title, by all means. I've been struggling with it for a while...
I'm using Excel to analyze a list of filenames for potential issues...special characters, excessive length, etc., before we run them through a script. Right now, I've got a column to test for the condition and a COUNTIF to count the occurences of the test results.
COL A COL B COL C filename =IF(LEN($A1)>200,"LONGNAME","") =COUNTIF(B1:B10000,"LONGNAME")
I would like to simplify this to something that's just COUNTIF(anythingInColumn,isLong) without having to create a separate column to test for whether or not something "is long".
COL A COL B filename =COUNTIF($A,LEN($A>200))
The problem with the above is that I see nothing that explicitly tests line-by-line for my condition, when I tried it, there did not seem to be an implicit line-by-line test. I
Is something like this doable, or is there another function to do this in a single step?