Results 1 to 2 of 2

Rank in order that List appears

Threaded View

  1. #1
    Forum Contributor 00Able's Avatar
    Join Date
    11-17-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    244

    Rank in order that List appears

    Is there a way I can take 2 lists that contain the same information, and rank it in the order it appears in List B?
    So If cell A2 = a1 and cell C4=a1 then cell B2 = 3rd


    List A Rank List B
    a1 3rd a10
    a2 4th a3
    a3 2nd a1
    a4 10th a2
    a5 5th a5
    a6 9th a8
    a7 8th a9
    a8 6th a7
    a9 7th a6
    a10 1st a4

    numbers can be 5, 6, 7, or 8 digits long, also this example is small I will be working with hundreds of number combinations.
    Last edited by 00Able; 01-20-2011 at 07:04 AM.
    Providing Problems for Your Solutions
    STARS are my Punching Bag, You will be rewarded.

    In the rare event that I may help you, feel free to make me see STARS

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