players

I have a Excel spreadsheet that consists of 6 worksheets. I include the following simply to provide a little background in preparation of asking a couple questions. The worksheets are as follows: Tennis Roster - max 20 players Schedule - For Tennis Doubles (i.e., 4 people needed to make up...

Hello, So I have this list of information which you can see below: In this chart I have a list of players (A - S), what their respective strength is, and the time they are able to cover in the time range 0 - 24. I am trying to figure out if there is a way to get excel (whether through a...

I've created a spreadsheet where I have a list of 24 golfers. These golfers have 12 "A" players and 12 "B" players. When I hit the sort button, they are randomly divided into 6 teams of 4 with 2 "A" players and 2 "B" players on each team. Now I want to do this for 3 days with no one golfer...

I'm a beginner working with VBA. I first used the "record a new macro" function in Excel to create my first set of Macro's. I progressed to the point of looking for snippets of code on the internet to accomplish specific tasks that needed to be done. However, I am very aware that my coding is...

I have a list of 100 names with associated golf scores/handicaps. I need to develop 5 Flights (A, B, C, D, E) into which players will be placed based on their score/handicap, e.g., players who score par to 10 over par (this is a variable) would be placed into Flight A; Players 11 to ? would be...

I have a group of 12 player in column A1 to A12 and have them numbered 1 to 12 in Column B - Looking to play golf in 3 teams of 4 over 6 days. Mixing the Guy's up so they get a chance to play with all the other Team Players (if possible) I have selected Column D to indicate Day 1 to 6 and...

Hi all, I have attached my document with my desired result in the link below (I can't figure out how to add an excel document to this page). Below is a quick summary of what I'm looking to do (it's also in the document). I appreciate all your help and please let me know if you have any...

I have written a macro (see below) and when I step through it I keep getting a Compile error: Loop without Do. but there is a Do While statement. I have searched through the VBA and Macros book and the web and can find no resolution. In the coding below I have tried to be as transparent as...

So basically the players names are B3:B14 Round tallies will be C3:C14 to L3:L14. I have the sum of all rounds in column M. I was able to set up a RANK column to show the users current rank using =RANK(M3,$M$3:$M$14,0)+COUNTIF($B$1:B1,B1)-1 However I would like to have a separate area which I...

I have a spreadsheet of values. They have baseball players names and total value (numerical). I was able to use SUMIF to calculate the total for every team's players. How can I use SUMPRODUCT to calculate the total of the top 5 players for every team?

I run a golf league and have created an extensive workbook that calculates the players handicaps on the scorecards. The problem I'm having is trying to add additional scorecards (adding rows) with out having to re-write the formulas for each cell. example: In row 18 the players handicap is...