+ Reply to Thread
Results 1 to 4 of 4

Phrase Density Macro Doesn't Detect Numbers?

  1. #1
    Registered User
    Join Date
    04-21-2009
    Location
    Puyallup, WA
    MS-Off Ver
    Excel 2010
    Posts
    55

    Phrase Density Macro Doesn't Detect Numbers?

    I have a two-part question. I have been using this phrase frequency Excel macro for years. It has two downsides:

    1. It doesn't include numbers in the output.
    2. If I wanted the output to exclude results that contained full phrases like "to, as, of, is, for, and, the"... is that possible? For example, if a 3-word phrase was 'for excel forum', because it contained the full phrase 'for', this 3-word value would not show up in the output (it would be excluded from the results because it contained the phrase 'for').

    In the attached, you can see keyword phrases in column A. When the Button is clicked, it creates 1-word, 2-word, 3-word and 4-word phrases based on the keyword list density in column A.

    Frequency Macro.xlsm

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Phrase Density Macro Doesn't Detect Numbers?

    some comments about the goal would be usefull
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    04-21-2009
    Location
    Puyallup, WA
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Phrase Density Macro Doesn't Detect Numbers?

    Frequency Macro - Example.xlsm

    For example, the attached shows 32 keywords in column A. The output in columns B, D, F and H do not include numbers in the density output.

    Likewise, in cell O2, I wrote a small list of stop words. I then highlighted the output in columns B, D, F and H that contain these phrases. The desired output is that all the cells highlighted yellow would NOT show up in the output because they contain at least one of those phrases from cell O2.

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Phrase Density Macro Doesn't Detect Numbers?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1