C
Christopher Naveen
Hi,
I use text formula and after saving the file using pastespecial to values I
can see a single quote (') in the blank cells. This is giving a problem to
CountA function.
Ex :
IF(WEEKDAY(A1,1)<=5,TEXT(A1,"DD-MM-YY"),"")
Using the above formula, if the condition is false it will show as blanks.
In the blank cell I am getting the output as single Quotes (').
Now I am trying to find out the count of non blanks in this col using countA
and it is counting all the blank cells also as it contains single quotes.
Can anybody help me to solve this
Christ
I use text formula and after saving the file using pastespecial to values I
can see a single quote (') in the blank cells. This is giving a problem to
CountA function.
Ex :
IF(WEEKDAY(A1,1)<=5,TEXT(A1,"DD-MM-YY"),"")
Using the above formula, if the condition is false it will show as blanks.
In the blank cell I am getting the output as single Quotes (').
Now I am trying to find out the count of non blanks in this col using countA
and it is counting all the blank cells also as it contains single quotes.
Can anybody help me to solve this
Christ