Common term on Twitter Network

Oct 21, 2011 at 4:21 PM

Somebody know if is possible to look for the freceuncy of the use of a term or word in a secific network with the twitter users that I defined?

Thanks in advance for your help

Kind Regards

Oct 21, 2011 at 6:38 PM
Edited Oct 21, 2011 at 6:40 PM

Here is one way:

1. Select NodeXL, Data, Import, From Twitter List Network.

2. In the Import from Twitter List Network dialog box, Check "Add a Latest Tweet column to the Vertices worksheet".

3. After the network is imported, switch to the Vertices worksheet.

4. Paste the following formula into an empty cell on the Vertices worksheet, substituting the term you're seeking for the word "text".  IMPORTANT: You must enter the formula with Control+Shift+Enter.

=SUM(LEN(Vertices[Latest Tweet])-LEN(SUBSTITUTE(Vertices[Latest Tweet],"text","")))/LEN("text")

This formula came from "Description of formulas to count the occurrences of text, characters, and words in Excel" at

-- Tony

Oct 22, 2011 at 12:22 PM

Wow great this program is fantastic!!

Thanks a lot for your reply tony.

Have a nice day