CODEWITHSUNDEEP
excel
user8421235
user8421235

Reputation:

How To Count comma, another cell Separated Values In all Column In Excel?

I know this is a programming site so, sorry If It's not that place to ask this question... I don't know where can I ask that...

I have a column in Excel and in every cell I have a set of worlds that Separated by a comma.

How can I count and get an array of the result of the count

for example in this column enter image description here

My expected result is (Or something that look like that to be able to create a nice Graph)

enter image description here

Upvotes: 1

Views: 129

Answers (1)

BigBen
BigBen

Reputation: 49998

Use COUNTIF with wildcards - something like this:

=COUNTIF($A$1:$A$6,"*"&C2&"*")

enter image description here

Upvotes: 3

Related Questions