Count specific entry

[Jeff88]

Hi,

I would like to seek your help with my data. I am trying to count  the exact entry from a specific column, however, it contains multiple words with characters. I just would liek to count specific entry (in my chase below its letter A)

Entries	Count
A,AB, BC;A B	1	should count (first letter A)
AB, BC; A B	Null
BC#A	1	should count
BC#BC,A	1	should count
BC, B A B#C	Null
BC,A#C	1

[DavidSkaife]

Hi @Jeff88 

If you're simply wanting to count the number of times the letter A appears then the Regex formula REGEX_CountMatches([Field], 'A') will work.

If you have more specific requirements you may need to explain a bit further for your example.

[Jeff88]

Hi David, 

Thank you for the prompt answer, however what i need to do is just to count the specific word, here's an example data again and what should i expect to reflect.

On a form, user can select multiple colors and when I extract my data to excel, it will show the table below and it was separated by special characters like ;

I only would like to count if the user selection includes "Red" not "Light Red" or "Dark Red"

If the field consist of "Light Red" and "Red", it should count as 1

If the field consist of "Light Red" and "Dark Red", it should not count

Item	Result (count)
Red	1
Dark Red; Light Red	Null
Red;Blue;Light Green; Light Red	1
Brown;Red;Dark Blue	1
Light Red, Blue	Null
Red, Dark Red, Light Red	1
Dark Red;Red;Brown	1
Light Red# Red	1

[Emmanuel_G · Accepted solution]

Hi @Jeff88 ,

You can find a test attached with exact desired output.

Let us know if it works the way you want.

Cheers !

[Jeff88]

This one works. Thank you so much  😁

[Emmanuel_G]

@Jeff88  Glad to know that 😁 !