79521081

Date: 2025-03-19 18:31:02
Score: 1.5
Natty:
Report link
=Countifs(A:A;"*"& B1 &"*")
A B C
1 Hello, my name is John, Hello, I'm John Hello, people =countifs(A:A;"*"& B1 &"*")
2 Hello, I'm John, Hello, people call me John Hello, my name is John =countifs(A:A;"*"& B2 &"*")
3 Hello, my name is John
4 Hello, people 
=COUNTIFs(A:A;"*"& "Hello, people" &"*")

An image of the function test:enter image description here

The" *" means any expression before and after it, so that the function counts every cell that contains your expression.

Reasons:
  • Blacklisted phrase (1): enter image description here
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: sedi