Hi
Need to count how many times the word cat and red appear in list below Range (B2:B8) Result should be 3. The word can appear any where in the cell
Result should be 3
doesn't matter if cat appears within a word as long as it appears its fine i.e. scatty red dog would count as well
Need to count how many times the word cat and red appear in list below Range (B2:B8) Result should be 3. The word can appear any where in the cell
Result should be 3
doesn't matter if cat appears within a word as long as it appears its fine i.e. scatty red dog would count as well
cat sheep dog |
blue dog black |
cat man red |
red cat |
cat blue |
dog red |
cat badger red |