Forum Discussion
Solved
Find in document working but COUNTIF is not.
Hi Community, I am exporting keyword data out of Google Ads into Excel. I am trying to use the countif function to count the number of occurrences of specific search words like "AI." =COUNTIF(A...
You may try
=COUNTIF(A2:A100, "*ai *")space here is to separate "ai " from ai within some words
You may try
=COUNTIF(A2:A100, "*ai *")space here is to separate "ai " from ai within some words
Thank you Sergei! The asterisks work beautifully. Problem solved.
While we're at it, I have another question. You can see in the sample data that there are instances of non-Latin script, I think Arabic and Chinese. Can Excel filter out or count data by the script used? I would like the ability to count the number of these instances, filter them out, or completely delete them.
While we're at it, I have another question. You can see in the sample data that there are instances of non-Latin script, I think Arabic and Chinese. Can Excel filter out or count data by the script used? I would like the ability to count the number of these instances, filter them out, or completely delete them.
DavidJ2210 , you are welcome
If you'd like filter them
- apply filter to entire range
- Text filter -> Custom filter -> is greater than "z"
- to delete select filtered rows, delete rows from right-click menu
- clear filter