Posts by samarrowhead

Re: Parts of speech count

You are a GENIUS!!! This is perfect and exactly what I was looking for! I truly can't thank you enough!

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.

Re: Find the most frequent phrases in a text string

The code does not have to be case sensitive and does not have to exclude stop words such as "an, a, the, or, and". If stop words can be excluded, then this is a plus!

Please find attached a sample workbook. Tab 1 includes raw text strings and Tab 2 includes desired output/results.

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?