Excel/List Sort


Hi, Using Excel 2010 I have a list of golf competition results for the year and want to find the 15 players with the sum of the best 4 net results. List headings are Name: Net: Some players have played more games than others so I donít want to include anyone who has played less than 4 games. Example of list below, up to 300 names in the list. Can this be done with a pivot table or does it need VBA? Any help appreciated.
Name          Net
ABBOTT John        76
ABBOTT John          76
ABBOTT John          79
ABBOTT John          84
ABBOTT John          76
ABBOTT John         82
ABBOTT John          87
ALLEN L          73
ALLEN L          85
ARKELL Darren James   67
ARKELL Darren James   74
ARKELL Darren James   74
ARKELL Darren James   76
ARKELL Darren James   76

Regards Alan


I am sure I could develop a non-vba solution for you or if you prefer, a VBA one.  If you want to send you sample data to twogilvy@msn.com  

I will take a look and provide you something.

Anyway, I don't see where a PivotTable contructed on just your existing two columns would be able to do this.  If some additional calculated columns were added, then perhaps a pivot table could be used.  

Tom Ogilvy

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Tom Ogilvy


Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]


Extensive experience.

Master of Science (MS) degree Operations Research (ORSA)

Awards and Honors
Microsoft MVP in Excel.

©2016 About.com. All rights reserved.