News, tips, advice, support for Windows, Office, PCs & more
Home icon Home icon Home icon Email icon RSS icon

We're community supported and proud of it!

  • Count entries

    Viewing 5 reply threads
    • Author
      Posts
      • #2273731
        WSbenjones76
        AskWoody Lounger

        Hello; hope all are safe and well.

        Attached is a table with a list of processes in Cell # A2.

        I need to count these entries and provide this in Cell # B2.

        Please help me with this; TIA. BJ

        Attachments:
      • #2273734
        Paul T
        AskWoody MVP

        The attachment is missing.
        Try attaching an XLSX or ZIP.

        cheers, Paul

      • #2273736
        Paul T
        AskWoody MVP

        You need to SPLIT the items at the carriage return and use UBOUND to find the array size. You can do this in a User Defined Function (it’s VBA).

        Something like this.

        Function CountProcess(sText As String) As Byte
            CountProcess = Ubound(Split(sText, vbCRLF))
        End Function
        

        cheers, Paul

        • This reply was modified 8 months, 2 weeks ago by Paul T.
      • #2273763
        WSbenjones76
        AskWoody Lounger

        Thank you for this; is there no way without the VBA?!

        BJ

        • This reply was modified 8 months, 2 weeks ago by WSbenjones76.
      • #2273774
        Paul T
        AskWoody MVP

        Not that I know.

        Why don’t you want to use VBA?

        cheers, Paul

      • #2274003
        anonymous
        Guest

        In this post, WSbenjones76 wrote:
        Attached is a table with a list of processes in Cell # A2.
        I need to count these entries and provide this in Cell # B2.

        In a different post, WSbenjones76 wrote:
        I need to count the number of entries in B2 and B3 – then give a total count in B4.

        Hello WSbenjones76.

        If you’d be willing to try to describe your problem more completely _in the text of your post_, in a way that doesn’t require someone to view your attachment to understand specifics regarding your request for assistance, then there’s a real chance you might receive more responses…

        Why? Anonymous contributors here on AskWoody are obviously not logged in, but the site requires that “You must be logged in to access attached files.” So anons are unfortunately unable to see your attachment (…unless, of course, they choose to first register and then log in – so really no need for anyone to reply stating the obvious 😉 ).

        But if you’re able to restate your issue in a way that distills the specifics of your spreadsheet problem, and includes sufficient description/detail of sample content/format of important representative cells…

        Obviously can’t guarantee in advance that you’ll receive other useful (non-VBA) solutions or suggestions, but maybe worth trying?

        Hope this helps.

    Viewing 5 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, no politics or religion.

    Reply To: Count entries

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.