The survey responses are stored like this in 2 columns. There are about 150 rows.
response choices
1 cats, dogs, turtles
2 cats, dogs, turtles, ducks
3 ducks, frogs
4 turtles, ducks
I am trying to count how many times each value was selected. So I want this output:
cats 2
dogs 2
turtles 3
ducks 3
frogs 1
I can't figure out how to do this!! Thank you in advance!
Try this
=COUNTIF($A$1:$A$5,"*"&B1&"*")
cats, dogs, turtles cats cats, dogs, turtles, ducks dogs ducks, frogs turtles turtles, ducks ducks turtles, ducks frogs
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
If you're prepared to split the column B strings with the Data Text To Columns functionality then the attached would be one way.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thank you Alkey! I tried that solution and it worked!!
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks