+ Reply to Thread
Results 1 to 2 of 2

list of words by frequency

  1. #1
    Forum Contributor
    Join Date
    04-23-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2013
    Posts
    116

    list of words by frequency

    Hello,


    I have a 300 page manuscript for which I want to create a list of the most often appearing words and their frequencies.

    For instance, using the above sentence:


    a: 2
    I: 2
    frequencies: 1
    have: 1
    page: 1
    the: 1

    and so forth...



    Any suggestions?

  2. #2
    Forum Contributor
    Join Date
    04-23-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2013
    Posts
    116

    Re: list of words by frequency

    Well I found code that works here:
    https://groups.google.com/forum/#!to...nt/rOA9U5kwses

    credit goes to Doug Robbins
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to sum frequency of duplicated words
    By jackorres in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2013, 02:46 AM
  2. Text Histogram for collecting words and their frequency
    By wali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2012, 11:19 AM
  3. ordering words by frequency
    By mogwai1968 in forum Excel General
    Replies: 3
    Last Post: 08-14-2011, 08:59 AM
  4. What excel function to use to generate some words with a certain frequency?
    By pocketrocket in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-01-2008, 03:25 PM
  5. [SOLVED] frequency of occurance of all words in 2-D array
    By Richard in forum Excel General
    Replies: 4
    Last Post: 03-21-2006, 11:15 AM

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