Forum Discussion
Count the exactly the same words from set of words
yoshiwata Perhaps the easiest way out, though perhaps not practical, would be to be aware of the instances that one keyword may be part of another keyword up front and slightly change such keywords. For instance, change "Cap" to "Cap_" and your formula will work.
If your real life problem is more complex than your sample, you may want to consider PowerQuery (PQ) as demonstrated. Then you can easily avoid the matching of Cap with White Cap.
I haven't looked into a formula based solution as it it so easy with PQ. Please see the attached file.
yoshiwata Perhaps the easiest way out, though perhaps not practical, would be to be aware of the instances that one keyword may be part of another keyword up front and slightly change such keywords. For instance, change "Cap" to "Cap_" and your formula will work.
If your real life problem is more complex than your sample, you may want to consider PowerQuery (PQ) as demonstrated. Then you can easily avoid the matching of Cap with White Cap.
I haven't looked into a formula based solution as it it so easy with PQ. Please see the attached file.
- Thank you so much! I will consider PQ as it brings a perfect result.
