J
JRD
How can I count cells that contain certain words without counting same cell
twice.
e.g.
Column A
1 blue, green, white
2 white, yellow, red
3 red, blue, cyan
4 green, cyan, black
5 indigo, green, blue
6 yellow, red. black
How can I count the number of cells that contain blue, white or green
The answer in this case would be 4.
Many thanks
John
twice.
e.g.
Column A
1 blue, green, white
2 white, yellow, red
3 red, blue, cyan
4 green, cyan, black
5 indigo, green, blue
6 yellow, red. black
How can I count the number of cells that contain blue, white or green
The answer in this case would be 4.
Many thanks
John