count itmes in a column that is populated with multiple data
I have a new challenge for you . I have a list of projects. Each project contains different products. I have one probabilty column that contains all the probabilities to sell the different products contained in each individual project.
An exaple: I have a project (1 row) where I can sell machines types A, B and C. The respective probabilities are: Prob_Machine_A(90), Prob_Machine_B(70) and Prob_Machine_C(90). The number in the parentheses are the actual probabilities. All these probabilities are contained in the cell crossing the prject name and the probability column, and they are separated by a semi-column.
Now imagine that I have a full list of different projects.
Now the challenge: I would like to count:
- all the project with the different machine types (how many proj. with machine type A, B etc...)
- all projects with probabilities > 70%
If anyone could help me with the first one, that would be a great help!
Thanks in advance.