+ Reply to Thread
Results 1 to 6 of 6

Ranking problem

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    São Paulo
    MS-Off Ver
    Excel 2010
    Posts
    5

    Ranking problem

    Hi I'm new here and I have the following problem: I have a sheet with approximately 72 companies and each day I update it with their respectively sales quantity obtaining the total number of items sold since the beginning of the month for each of them. I would like to create a new sheet in the same Workbook that could rank which companies are selling more until the moment (it needs to show the names of the companies in a descending order with the respectively total items). Until now I'm using the function =RANK() that returns the rank of total items sold in a list of numbers, the problem is that it's hard to find in which position is each company looking to the classification (numbers) obtained by the function above, so it would be nicer if it showed the name of these companies in the ranking instead of the numbers created by =RANK().


    Thanks in advance

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Ranking problem

    Can you upload a dummy file for others to look at.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    05-08-2012
    Location
    São Paulo
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Ranking problem

    Rank.xlsx
    Here is an example with less companies and days.

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Ranking problem

    hello maybe you could work this sample out.

    Ranksampler.xlsx

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Ranking problem

    i only have 2003 on this machine, so i cant see vlady's solution, but if they havnt already suggested it, instead of using rank(), use small(). hope his suggestion worked for you tho
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    05-08-2012
    Location
    São Paulo
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Ranking problem

    Thank You it worked great

+ 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