Search for a string in cells in a column and diplaying a count...

[amarss]

Here's what I have:
cell1 - red, blue, yellow
cell2 - green, purple, yellow
cell3 - cyan, black
cell4 - red, black
cell5 - magenta, purple, teal
cell6 - brown, pink, teal

What I need:
red - 2
blue - 1
yellow - 2
green - 1
... and so on for each colour

How do I get the above results in google sheets???

[Pete_UK]

This is an Excel forum - how are we to know if Google sheets is compatible?

In Excel you could do this in D1:

=COUNTIF(A:A,"*"&C1&"*")

assuming your mixes of colours are in column A, and that your first colour (red) is in C1, with the other colours below it. Copy the formula down as required.

Hope this helps.

Pete

[AlKey]

Try this

in B1

=COUNTIF($A$1:$A$6,"*"&C1&"*")
and drag formula down

	A	B	C
1	red,blue,yellow	2	red
2	green,purple,yellow	1	blue
3	cyan,black	1	green
4	red,black	2	black
5	magenta,purple,teal	1	magenta
6	brown,pink,teal	2	purple
7		2	teal
8		1	brown
9		1	pink
10		2	yellow

[amarss]

Thanks Pete and Alkey, your solutions worked.
First post here and love the quick response.

Thanks again.

[Pete_UK]

Well, thanks for feeding back, and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete