Nov 21 2021 10:13 PM
Ive been tasked with determining who the top 8 riders are in points. I have the spreadsheet with the points from the season, but I do not how how to create a formula to find the total overall points a rider has because some have riden in multiple divisions. Anyone able to help?
Nov 21 2021 11:45 PM
Solution@momtomari You would want to put all the results in on single table with three columns (Division, Rider, Total Points). No empty rows or columns. Then you can create a pivot table and sort it as you like. The attached workbook contains an example in the tab "Data and PT".
Nov 21 2021 11:45 PM
Solution@momtomari You would want to put all the results in on single table with three columns (Division, Rider, Total Points). No empty rows or columns. Then you can create a pivot table and sort it as you like. The attached workbook contains an example in the tab "Data and PT".