Text Formula Error

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top