Posts by samarrowhead

    Re: Parts of speech count


    Thank you! I tried using different lookup/count formulas which did not result in much success (very likely because I am doing something wrong). Attached is a sample workbook where Sheet 1 contains the various text strings and placeholder cells for nouns, adjectives, verbs and adverbs. Sheet 2 contains the glossary of nouns, adjectives, verbs and adverbs. I don't know how to cross-reference these lists in order to count the different parts of speech by text string.

    Looking for a way to count parts of speech in an Excel text string. I have a list of text strings in Column A and the following labels in Columns B to E: Noun, Adjective, Verb and Adverb. I want to know how many of each (Noun, Adjective, Verb, Adverb) are identified by text string. For example:



    [TABLE="width: 500"]

    [tr]


    [td]

    Text String

    [/td]


    [td]

    Noun

    [/td]


    [td]

    Adjective

    [/td]


    [td]

    Verb

    [/td]


    [td]

    Adverb

    [/td]


    [/tr]


    [tr]


    [td]

    The quick brown fox jumped over the lazy dogs.

    [/td]


    [TD="align: center"]2[/TD]
    [TD="align: center"]3[/TD]
    [TD="align: center"]1[/TD]
    [TD="align: center"]0[/TD]

    [/tr]


    [tr]


    [td]

    John likes fast blue cars.

    [/td]


    [TD="align: center"]2[/TD]
    [TD="align: center"]1[/TD]
    [TD="align: center"]1[/TD]
    [TD="align: center"]1[/TD]

    [/tr]


    [tr]


    [td]

    Etc.

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Etc.

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]



    While I understand performing such calculations is highly hinged on context and the English language contains various grammar rules, etc. I am not looking for a perfect solution but anything that can get remotely close would be tremendously appreciated.

    I have a list of text strings and I want to know which two phrases occurred the most often in all of my text strings. For example:


    i want to purchase a new phone
    considering the purchase of phone
    want to buy some tools


    The results would be:
    purchase phone = occurred 2 times
    want to = occurred 2 times


    Can anyone help please?