I keep track of real driver statistics (Nascar) and am involved in an online racing league and keep track of those stats as well. I've made a workbook consisting of two main worksheets.

The first worksheet is for Overall Stats and the column headings consist of driver names, prize money, points, bonus points, wins, poles, top 5's, etc. The second sheet I've named Data Entry sheet which consists of a separate chart for each column listed in the first sheet. In other words I have a Prize Money chart and enter the winnings manually and then the totals after every race are updated and linked to the Overall Stats sheet.

The first issue I'm having is the sort feature. After a race I want to sort by an individual category . First I may want to find out which driver is leading in overall points and then which won has most wins, etc. I select the entire Overall Stats sheet (Ctrl + A) and select Sort from Data menu. (I have do not have any merged cells in any of the charts). I want to sort in descending order, as my preference, and then will select the category by which I want to sort. Regardless of which category I sort by, the issue is that the drivers are not matching up with the points or winnings that should be assigned to them. It's as if the rows consisting of each individual drivers stats are swapped with another driver.

The second issue I'm have is regarding the points column. In Nascar there are 36 races. After the first 26 races are complete, the top 10 drivers in points are in a race for the championship trophy for the final 10 races and are awarded additional points. In my spreadsheet I would like to incorporate a formula that will determine the top 10 drivers after 26 races and then add the appropriate points to those drivers. Not sure if this is feasible.

I appologize for the long post and am a fairly new user to Excel. I'm learning my formulas from feedback I receive and others who post in the Online Community. Any help would be much appreciated.

Thanks very much in advance