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???
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???
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
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.
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
Or maybe use a pivot table
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
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???
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks