S
Seeker
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 didn’t see your reply in general question, may be you don’t
bother to check those "muti-post" anymore. In fact the “muti-post†was caused
by the error message of “service not availableâ€, I didn’t 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.
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 didn’t see your reply in general question, may be you don’t
bother to check those "muti-post" anymore. In fact the “muti-post†was caused
by the error message of “service not availableâ€, I didn’t 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.