+ Reply to Thread
Results 1 to 3 of 3

Sort by Highest Frequency

  1. #1
    Registered User
    Join Date
    07-28-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Sort by Highest Frequency

    I have thousands of values that I'm trying to organize together. I need to sort to find similar values, and order them from highest to lowest frequency.

    Example:

    www.google.com
    www.google.com
    www.google.com/maps
    www.yahoo.com
    www.yahoo.com/sports

    I need to filter and sort to group like URLs together, then order from high to low.

    Thank you!!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,903

    Re: Sort by Highest Frequency

    I'm not clear what you're asking for.

    Have you got a file containing these thousands of values? If so why not use Excel's standard sorting functionality.

    Not sure why you've posted links to web sites. Are you wanting to grab tables of data from the sites, in which case you'll need to be more specific.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Sort by Highest Frequency

    First use TextToColumns to parse your data to an empty column.

    Step 1: Delimited
    Step 2: Check "Other" and enter / in the box.
    Step 3: Change destination range to vacant column. In the Data Preview, with the exception of the first column which should be left as "General", select each column in turn and set the radio button at the top to "do not import column (skip)"

    Next, in another empty column enter the formula,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Note that A:A should refer to the column holding the original list, A2 should refer to the first entry. Fill the formula down to the end of the list.

    Sort first by the text to columns output, then by the formula results in descending order.

+ 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