Closed Thread
Results 1 to 3 of 3

Sort by frequency of occurrence

  1. #1
    Valued Forum Contributor
    Join Date
    10-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    513

    Sort by frequency of occurrence

    Hi,

    I have a column of texts to sort by frequency of their occurrence, but I am not sure how to proceed. Please see the attached.

    Please don't mistake them by numbers. They are supposed to be texts.

    So at the end of the day basically I would like to have a sort that will put 486 at the top, then 038.9, and then 576.1, etc.

    Can this be done in Excel? or is this getting into VBA? How do you track the number of occurrences for each text in the column?

    Thank you for taking the time.
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Sort by frequency of occurrence

    Your document appears to be password protected.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Sort by frequency of occurrence

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed 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