Re: Excel / COUNTA function is not working properly

[Joe Wood <wood3875@xxxxxxxxx>]

Peter,

"I am using ODBC connections to refresh the data on the spreadsheet
automatically, so the downloaded data can be different from time to time."

Could you share the details/configuration/version of your ODBC DB2
connections and Excel version ?

Thanks !




On Mon, Nov 18, 2013 at 9:22 AM, Vidal, Peter
<Peter.Vidal@xxxxxxxxxxxxxxx>wrote:

> Friends,
>
> I downloaded data from a DB2 file to a spreadsheet.  I am trying to use
> the COUNTA function to detect how many asterisks "*" I have in a column.
>  In this column I am supposed to have asterisks or blanks.  I have 1772
> rows and when I execute the function, is returning 1772 as the count so I
> know that the apparent blanks are not really that.  How can I improve the
> function so I can count the number of asterisks only and not count those
> "invisible strings" I am downloading?
>
> I am using ODBC connections to refresh the data on the spreadsheet
> automatically, so the downloaded data can be different from time to time.
>
> Thanks in advance,
> Peter Vidal
> SR Technical Specialist
> P: 800-808-1902, x137210
>
> [cid:image001.gif@01CEE44E.A048F140]
> 9119 Corporate Lake Dr., Suite 300 | Tampa, FL 33634 | www.carecentrix.com
> <http://www.carecentrix.com/>
>
>
> ________________________________
> This communication is intended only for the use of the individual or
> entity named as the addressee. It may contain information which is
> privileged and/or confidential under applicable law. If you are not the
> intended recipient or such recipient's employee or agent, you are hereby
> notified that any dissemination, copy or disclosure of this communication
> is strictly prohibited. If you have received this communication in error,
> please immediately notify CareCentrix Compliance Hot Line at (877)
> 848-8229 and notify the sender by electronic mail. Please expunge this
> communication without making any copies. Thank you for your cooperation.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.