Count frequency of exact text string. Exact text and character count need to match

  • 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"]

    [tr]


    [TD="class: xl65, width: 229, bgcolor: transparent, align: left"]Criteria
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl66, bgcolor: transparent, align: left"]Planning
    [/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="class: xl65, bgcolor: transparent, align: left"]Range
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl66, bgcolor: transparent, align: left"]Planning
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl66, bgcolor: transparent, align: left"]Planning 1
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl66, bgcolor: transparent, align: left"]Planning 2
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl66, bgcolor: transparent, align: left"]Planning Permission
    [/TD]

    [/tr]


    [/TABLE]



    Any help would be greatly appreciated.


    Many thanks


    James

  • Re: Count frequency of exact text string. Exact text and character count need to matc


    Not sure I get it... Why bother with a wild card at all if you are looking for an EXACT match?


    when I used:
    =COUNTIF(C1:C4,A1)


    I get 1....


    You cant use a wild card and search for an exact match... you cant have it both ways (with one formula anyway)


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!