Hi guys,
Always managed to find my answers on here by searching but this one seems to have eluded me.
I am counting the frequency of specific text strings using a wildcard but the problem is my count is overstated due to the formula picking other text string that start with the same naming convention.
In the scenario below I need the count to return 1 with "Planning" as my criteria. Unfortunately though, any formula I use returns a count of 4 and I cannot find a combination of formulas to return the "exact" text string only and not just if it forms part of another string. I have tried everything and am totally stuck. I have tried a combination of sum and len and various countif/(s) with a text wildcard but can't get anything to work.
[TABLE="width: 172"]
[TD="class: xl65, width: 229, bgcolor: transparent, align: left"]Criteria
[/TD]
[TD="class: xl66, bgcolor: transparent, align: left"]Planning
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: left"]Range
[/TD]
[TD="class: xl66, bgcolor: transparent, align: left"]Planning
[/TD]
[TD="class: xl66, bgcolor: transparent, align: left"]Planning 1
[/TD]
[TD="class: xl66, bgcolor: transparent, align: left"]Planning 2
[/TD]
[TD="class: xl66, bgcolor: transparent, align: left"]Planning Permission
[/TD]
[/TABLE]
Any help would be greatly appreciated.
Many thanks
James