Dear volunteers,
Is there any speedy way to count text values including empty cells same as
array-frequency. My column A contains "text" which are output of value from
other cell by using copy-past special-value, counting need to consider empty
cells.
I tried this, it works but too time costly
Range("A1").FormulaArray = _
"=IF(B1=""ADD"",SUM(IF(FREQUENCY(IF(LEN(A2:A65536) 0,MATCH(A2:A65536,A2:A65536,0),""""),
IF(LEN(A2:A65536)0,MATCH(A2:A65536,A2:A65536,0)," """))0,1))+1&"".1"",""Input Order Number"")"

To Rick Rothstein,
Dear Rick, I didnt see your reply in general question, may be you dont
bother to check those "muti-post" anymore. In fact the €œmuti-post€� was caused
by the error message of €œservice not available€�, I didnt mean to do the
"muti-post". Regarding your suggestion, it only works for my column B I am
looking for column A now. Above in fact is the same question but showing in a
different manner, hope this is easier for you to know what I am looking for.

Thanks again guys for your help.