This is a personal project, I've been collecting pickup basketball scores for the past 6 months in the following format:
Here, the team on the left (5 players) matched up with the team on the right and won, 18-9 (all games are to 18)
I have ~105 games in my database currently with around 25 unique player names. I'd like to get a win-loss record for each unique player, as well as matchup data against each player (in this example Taylor was matched against Mike, Bryan against Bret, etc).
I'd also like to be able to punch in 2 names and find all the games that those two have played on the same team and get a win-loss record for the duo.
46 freelancers are bidding on average $118 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
Hi! Can I help you? Relevant Skills and Experience I have a great experience with excel and macro. I can make a good solution! Proposed Milestones $100 USD - Completed task