+ Reply to Thread
Results 1 to 7 of 7

Top ten list

Hybrid View

  1. #1
    Registered User
    Join Date
    11-29-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    15

    Top ten list

    I am looking to do a top ten list on another worksheet inside of a current workbook. I have a list of ppls names and their total points and am looking to create a list of the top ten ppl and their points. How do I do this???

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Top ten list

    sorting the list by the total points in descending order (largest to lowest). hit the home menu, go to the sort and filter option, select sort. make sure to check on the right hand top if you have headings (so it does not sort the headings). select the column in which the points are and on the righest option select largest to lowest

  3. #3
    Registered User
    Join Date
    11-29-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    15

    Re: Top ten list

    Problem with that is that the list I need to sort is in a different sheet. Second, I have a hundred numbers and only want the top ten.

  4. #4
    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
    53,048

    Re: Top ten list

    Take a look at using the LARGE() function for this. If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    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

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,654

    Re: Top ten list

    Or maybe use a pivot table
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  6. #6
    Registered User
    Join Date
    11-29-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    15

    Re: Top ten list

    2015 Schedule.xlsxPool League Score Sheets.xlsx
    Ok, first, I need to insert the Pool League Score Sheet into the other workbook w/o any changes to the lay out.
    I need to be able to insert scores for 25 weeks for 12 teams on multiple sheets.
    I need the "W"'s at the bottom to have check boxes so when checked, they add totals to team wins in the Team wins & Top Players Sheet.
    Then, I need Team wins and Top Players sheet to pull the men Top 10 & Women's top ten from the weekly results sheet

    Would this be easier in access and how would I go about setting that up???

  7. #7
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Top ten list

    Here is a link to a You Tube video that does just what you are looking for. See the attached file.


    HTML Code: 

    Jim O
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 02-22-2015, 11:40 AM
  2. Replies: 3
    Last Post: 04-22-2014, 03:30 PM
  3. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  4. [SOLVED] Taking a list of tasks and a list of subtasks and creating a new list with groupings
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2012, 12:16 PM
  5. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  6. list 1 has 400 names List 2 has 4000. find manes from list 1 on 2
    By Ed in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-12-2005, 05:05 AM
  7. list 1 has 400 names List 2 has 4000. find manes from list 1 on 2
    By Ed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12: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