+ Reply to Thread
Results 1 to 6 of 6

comparing lists-find each companies rank,

  1. #1
    Registered User
    Join Date
    05-24-2007
    Posts
    73

    comparing lists-find each companies rank,

    I have 3 lists. Each list has 100 company names and they are ranked 1 through 100. The company names are the same for each list. BUT, on each list the company is ranked in a different order. What I want to do is average all the ranks together. Instead of manually cutting and pasting each company name to put them on the same row, is there a way to automatically find each companies rank, then average them?

    Thanks for your help

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    re: comparing lists-find each companies rank,

    I couldn't open your attached sample workbook



  3. #3
    Registered User
    Join Date
    05-24-2007
    Posts
    73

    re: comparing lists-find each companies rank,

    i dont have one

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    re: comparing lists-find each companies rank,

    So what about
    I have 3 lists

  5. #5
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    re: comparing lists-find each companies rank,

    jspinx,

    See attached. Is something like that what you're looking for?

    Hope that helps,
    tigeravatar
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-24-2007
    Posts
    73

    re: comparing lists-find each companies rank,

    yes thank you.

+ Reply to Thread

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