+ Reply to Thread
Results 1 to 3 of 3

Finding the Top Three

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Philadelphia
    MS-Off Ver
    Excel Max 2013
    Posts
    1

    Question Finding the Top Three

    I need to pull the top three items to display in a report. Sorting is not an option due to other limitations. I need to pull the top three from this list, but am running into errors because there are multiple of the same value. This means pivot tables return more than three values, and the LARGE function returns the same value twice.

    Here is an example:

    Apples 50%
    Bananas 25%
    Oranges 25%
    Kiwis 0%
    Guava 0%

    When I use pivot charts for top 3, it pulls all five of these. When I use the large function, it pulls Bananas twice.

    Please help!

  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: Finding the Top Three

    tzhuff,

    Welcome to the forum!
    Attached is an example workbook based on the criteria you described.
    Row 1 is a header row, so actual data starts in row 2
    Column A contains the item names
    Column B contains their percentages
    Column D contains the top 3, which are obtained using this formula in cell D2 and copied down:
    Please Login or Register  to view this content.

    Does that work for you?
    Attached Files Attached Files
    Hope that helps,
    ~tigeravatar

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

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

    Re: Finding the Top Three

    Alternatively, you could use the Autofilter on the percentage column to filter for the top 3 items.

+ 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