+ Reply to Thread
Results 1 to 4 of 4

ordering words by frequency

  1. #1
    Registered User
    Join Date
    08-14-2011
    Location
    Hamburg, Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    ordering words by frequency

    Apologies in advance for what may be a simple question, but I am not a regular Excel user.

    I have 31 daunting pages of SAP terms in English with their German equivalent Excel translations. My task is to design a language workshop for my German students.

    I want to know how Excel can (if possible) rearrange my pages so the words or terms appear in order of frequency of appearance.

    Many thanks in advance for any help you can give.

    Cheers,

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: ordering words by frequency

    Can you provide an example?
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    08-14-2011
    Location
    Hamburg, Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: ordering words by frequency

    Thanks for the reply.

    Here are a few example pages from the original dictionary to give you an idea. I've grouped together all the codes in column C - that 'trimmed' file is on my office computer.

    The bottom line is that I am looking for the most frequent words either in German or English as a basis of designing the language course.
    Attached Files Attached Files

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: ordering words by frequency

    In the example, I've copied column A to column F and used the remove duplicates tool on the data ribbon to get unique values. I've then used a COUNTIF function to calculate the frequency.

    Does this get you any closer.

    An example of what you would like the output to look like would be useful.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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