+ Reply to Thread
Results 1 to 3 of 3

Top 5 Items Formula

  1. #1
    Registered User
    Join Date
    06-05-2010
    Location
    Syracuse, NY
    MS-Off Ver
    Excel 2007
    Posts
    8

    Top 5 Items Formula

    Hi guys,
    I'm working on a table of Weekly Apple sales for my job. What I'm trying to figure out is how to generate a List of Top 5 Total Sales Items.

    Column A = Apple Varieties
    Column B-T = Sales of each variety for individual weeks
    Column U = Total Sales
    Column X = Highest Sales

    What I need is a formula that will rank the five highest numbers in Column U and output the name associated with each highest total in Column X. Gonna keep tinkering with it, but any help is appreciated. Thanks.

    ~Dustin

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

    Re: Top 5 Items Formula

    Assuming data has headers, put this formula in cell X2 and copy down to cell X6:
    =INDEX(A:A,MATCH(LARGE(U:U,ROW()-1),U:U,0))
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-05-2010
    Location
    Syracuse, NY
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Top 5 Items Formula

    Thanks, that worked great. Appreciate the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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