Count entries

[WSbenjones76]

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:

You must be logged in to access attached files.

Reply | Quote

[Paul T]

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

cheers, Paul

Reply | Quote

[Paul T]

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.

Reply | Quote

[WSbenjones76]

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

BJ

• This reply was modified 8 months, 2 weeks ago by WSbenjones76.

Reply | Quote

[Paul T]

Not that I know.

Why don’t you want to use VBA?

cheers, Paul

Reply | Quote

[anonymous]

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.

Reply | Quote

[Author]

Posts