+ Reply to Thread
Results 1 to 3 of 3

Display top three results based on column, based on major

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    3

    Display top three results based on column, based on major

    In my table I have in column A, students' first choice in major when they apply, and in column B, the degree they eventually earn. In column C I have the percentage of students that end up following that pathway. Based on the percentage in column C, I only want to display the top 3 degrees for each major listed in column A.

    My table has 6K+ rows; how can I do this when each major in column A has varying numbers of degrees in column B? Macro? Something I don't know about with pivot tables?

    table.png
    Last edited by alexllap; 07-18-2017 at 02:29 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Display top three results based on column, based on major

    Hey Alex,

    See the attached where I've done what I think you want. You just need to create the correct value filter using Top...
    Top 3 in Pivot Table.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Display top three results based on column, based on major

    The TOP 10 feature found in the VALUE FILTERS is the way to go.

    Using the layout shown here, now right-click on one of the "degree" items listed in the Pivot table, then choose FILTERS > Top 10 and set it to show the top 3.
    PivotTop10.jpg
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Display results based on certain categories of users
    By tnovak in forum Excel General
    Replies: 2
    Last Post: 10-14-2014, 12:51 PM
  2. Excel Sheet to Display results based on a value
    By anthony.maddick in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-26-2014, 08:26 AM
  3. [SOLVED] Display results from a list based on multiple column filters.
    By Snoddas in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-12-2014, 12:41 AM
  4. Display numerous results based on three criteria
    By 54321adam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2013, 12:13 PM
  5. Display Results in a new worksheet based on Criteria Data
    By moliveiramrw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-08-2013, 10:20 AM
  6. Display Top 20 results based on certain criteria
    By ash_farooq in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-11-2012, 02:54 AM
  7. Replies: 1
    Last Post: 03-20-2009, 08:05 PM

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