+ Reply to Thread
Results 1 to 9 of 9

List Top 5 Names from Range

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2011
    Posts
    44

    List Top 5 Names from Range

    Hello,

    I am creating a spread sheet for ranking various restaurants. I have an "Average Rating" Column with a value assigned for each restaurant. I have created a box labeled "Top 5" and I would it to populate the names of the restaurants with the top 5 average values. As the values change, I would like the list to be dynamic as to change the hierarchy of names.

    I have attached the spread sheet.

    Column B is the Restaurants and Column R contains the corresponding values per restaurant. The formula should be inputted into cell T3 and go down to T7.

    Thank you for your help.

    Ranking Project.xlsx

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: List Top 5 Names from Range

    Put this in T3 and Drag Down:

    Please Login or Register  to view this content.
    Then change the red number to 2,3,4,5
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2011
    Posts
    44

    Re: List Top 5 Names from Range

    Hey xladept,

    Thank you for your help. I am getting a #NUM! display. Is there a problem with my cell format?

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: List Top 5 Names from Range

    Here's your file back, it's working on my machine
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-22-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2011
    Posts
    44

    Re: List Top 5 Names from Range

    I have attached my file. If you don't mind taking a quick look to see if you can find the error it would be much appreciated.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-22-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2011
    Posts
    44

    Re: List Top 5 Names from Range

    Hmmm now it is only showing the formula after i move out of the cell.

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: List Top 5 Names from Range

    The red number is missing


    Please Login or Register  to view this content.

  8. #8
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: List Top 5 Names from Range

    I had to unmerge the cell and I put the dollar sign on the row numbers:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: List Top 5 Names from Range

    Hi btone,

    Thanks for the rep and the compliment!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search a range Last Names for age & return the value to a List of FULL NAMES
    By LunarLights in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2014, 05:02 PM
  2. [SOLVED] Draw random names from list and then remove, carry on till no names left in list
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:14 PM
  3. Arrange List of Names in range table
    By bopsgtir in forum Excel General
    Replies: 5
    Last Post: 12-18-2010, 06:13 AM
  4. List Range names in VBA
    By Barry Au in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2007, 04:49 PM
  5. Replies: 2
    Last Post: 06-19-2006, 06:10 AM
  6. Range names list via ADO
    By Christophe QUEVAL in forum Excel General
    Replies: 0
    Last Post: 11-10-2005, 04:25 AM
  7. [SOLVED] List box: Populate with Range Names
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2005, 07:05 PM

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