Hello guys and girls,
I just arrived on this forum and I think it is the best Excel community I've discovered until now. I am currently having an Excel issue. I have a table with mentions of a specific car brand from social media channels. I have to analyse the discussions and show the number of time a specific model of the car has been mentioned in all the mentions that are collected.
Below you can see more exactly what I want to achieve.
<tbody>
</tbody>
There are 2 issues I don't know how to solve:
I would really appreciate your help. I hope I was clear.
Thank you!
Alex
I just arrived on this forum and I think it is the best Excel community I've discovered until now. I am currently having an Excel issue. I have a table with mentions of a specific car brand from social media channels. I have to analyse the discussions and show the number of time a specific model of the car has been mentioned in all the mentions that are collected.
Below you can see more exactly what I want to achieve.
Brand mentions | Model A90 | Model B60 | Model C30 |
Lorem ipsum A90 | 1 | 0 | 0 |
Lorem ipsum a 90 text text | 1 | 0 | 0 |
A 90 more text more text | 1 | 0 | 0 |
asdfa B 60 asdas asd | 0 | 1 | 0 |
b 60 text text text | 0 | 1 | 0 |
sad C30 bag | 0 | 0 | 1 |
asdasd c30. | 0 | 0 | 1 |
asdas dadsda sda | 0 | 0 | 0 |
<tbody>
</tbody>
There are 2 issues I don't know how to solve:
- The text from the first coloumn is including the value but not alone. So COUNTIF or VLOOKUP didn't helped me, or I didn't knew how to set them.
- I want to search for more than one value (so not only search for A90 but search for "A90" AND "A 90" AND "a90" AND "a 90")
I would really appreciate your help. I hope I was clear.
Thank you!
Alex
Last edited: