Hi
Not clear to me.
Can you clarify?
1 - can the word video appear more than once in a cell, like "video 1 is working video 2 is not working"?
What do you want to do in that case?
2 - can the word video appear as part of another word, like videogame, videocard?
What do you want to do in that case?
Could we assume the word separator is always the space character like in your examples, or can there also be others (which others)?
When you say it doesn't work, what does it return for that sample data?countif(B1:B4, "*video*") doesnt work.
Excel Workbook | ||||
---|---|---|---|---|
B | C | |||
1 | video not working | 2 | ||
2 | youtube video | |||
3 | hello | |||
4 | yes | |||
COUNTIF |