Results 1 to 6 of 6

Match items in two ranked lists

Threaded View

jim e. Match items in two ranked... 09-23-2009, 12:59 PM
NBVC Re: Match items in two ranked... 09-23-2009, 01:03 PM
jim e. Re: Match items in two ranked... 09-30-2009, 01:28 PM
NBVC Re: Match items in two ranked... 09-30-2009, 01:46 PM
jim e. Re: Match items in two ranked... 10-01-2009, 08:39 AM
NBVC Re: Match items in two ranked... 10-01-2009, 09:14 AM
  1. #1
    Registered User
    Join Date
    09-23-2009
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Smile Match items in two ranked lists

    I want to sort and match items in a ranked list without losing their ranking. I have attached a picture of the first 20 rows of data.

    Column A is the frequency ranking for a list of words in Column C
    Column E is the frequency ranking for a list of words in Column D

    I want to learn how to sort columns C and D (the words) so I can see identical words matched up next to each other, keeping the correct ranking in the column next to each word. e.g., I want Excel to show me by a sort which items in one list have an identical partner in the other list.

    jim e.
    Attached Files Attached Files
    Last edited by jim e.; 10-01-2009 at 08:38 AM. Reason: add illustration

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