# Randomly Pair Up Players

Nov 19, 2012

I am trying to make code to randomly pair up players. I have found code which makes a button that randomly pairs up players in a list but I want to make it so that ? players are paired with ? other players instead of everyone at the same time so that a person dosn't get paired with more then one player at a time.

E.g. take the first 6 players in a last and pair them with the second 6.

This is the code I found:

Private Sub CommandButton1_Click()
Dim x As Range, RanRng As Range, z As Range, oRes, Ray
Dim i As Integer, j As Integer, real, oSt As Integer, cl As Range
Dim oCol As Integer
Set RanRng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))

[Code] ........

## Randomly Pair Players Together To Form Teams

Jun 10, 2008

I need to randomly pair players together to form teams.

For example:
Saturday morning, there are 19 golfers signed up to play together, but want to paired randomly.

This is what we currently do:
In cells A1:A27 I type their names. In B1:B27, I type their handicaps.

We then use a deck of cards to randomly draw teams. We do this by pulling 4-A's, 4-k's, 4-Q's, 4-J's, and 3-10's from the deck. We shuffle these cards and then go down the names in colum A and assign each palyer a card and place the card value into column C. We then highlight all three columns and sort by column C to form teams.

This works ok, but the problem is they all tee off at the same time and need a "super quick" process to form teams in seconds.

The only variable that I might see being a problem is the # of players vary each time they play. There might be 12 one day and 51 the next. We have to form teams into 4 somes and 3 somes, based on the total number of players we get.

## Randomly Assign Players To Teams

May 5, 2007

I am trying to assign a list of players onto teams but I need to distribute "skill" evenly to ensure teams are equally matched.

A statistician in the league suggested the best way to do this might be to sort the player list (descending) by the measure of "skill", then start assigning teams in blocks. If I have 40 players in the league / 4 teams = 10 players per team. I would randomize the numbers 1-4 (e.g. 3 1 4 2) and assign them to the first four players, randomize another set of 1-4, assign them to the next, and so on...

I could then sort the player list by “team assignment” column and have hypothetically equal skill on every team.

Couple of complications... number of players and teams might vary season to season. I will have to enter in number of teams and number of players at the beginning of each season along with a new list of their stats. Also, although I have a limited knowledge of Excel and VBA, none of the other coaches do so I want to make this as idiot proof as possible.

Using various macros (or functions) I found here I was able to randomize the first "block" of players but I cannot complete the randomizations for the remainder of the list. The only solution I have found would be to manually create an array using the “RandUnique” function over X (depending on number of teams) cells and then copy and paste this randomized subset down the rest of the player list.

See attached for sample data.

## Trim In By The Players

Oct 17, 2009

Iam pulling hockey stats from yahoo sports into excel on one tab then i have other tabs as teams and iam pulling the stats from the yahoo sports tab to them

the yahoo tab is called Players but when yahoo bringis in the players names they come with a space in front of them. Now the formula iam using works if i go to the players tab and take the space out but as soon as I refresh the data it puts the space back.

here is what iam using
=IF(ISNUMBER(MATCH(TRIM(\$D5), Players!\$A\$1:\$A\$635,0)),INDEX(Players!NHL_2010_skaters, MATCH(TRIM(\$D5), Players!\$A\$1:\$A\$635,0), MATCH(E\$4, Players!\$A\$1:\$AT\$1, 0)),0)

I think i have to put trim in by the players but when i try and add it I get formula errors.

## Compare 1 Player To 3 Other Players

May 22, 2009

I need a formula for comparing the scores of 4 players from games won or tied.
I want to know for each game who won, tied or lost.

Below is how I compare 1 player to another.
=IF(P12

## Add Each Players Total From Each Course They Played

May 28, 2009

I have a column that adds the total points for each Golfer at each Golf Course. (Column AI)
I've added another column that I want to add the total points for each Golfer from each Course played. (Column AJ)

How can this be done so that it adds each players total points for each Course Played? There could be more Courses as well.
Would I use a: (=IF(Course=Courses,Vlookup(Course,B2:B65536),35,False) with a Sum???

Below is how it would look shown in RED:
Report

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ2DateGolf CourseIDTeam IDNameHCP123456789OUT101112131415161718INTotal ScoreNet ScoreStable ford PointsFront Holes WonBack Holes WonTotal Holes WonTeam ScoreTeam NetTeam Stable ford PointsCourse Stable ford Points324-MayRiverview0001001Player 13066666666654666666666541087829000108782943424-MayRiverview0002002Player 2195454534443844444444436745552101745552104524-MayRiverview0003003Player 330666666666545555555554599693800099693858624-MayRiverview0004004Player 416444444444365555555554581654200081654280725-MayEagle Bend0005001Player 11878666666657666666666541119314000111931443825-MayEagle Bend0006002Player 2334666555554755554454441885552000885552104925-MayEagle Bend0007003Player 316666666555515666666665310488200001048820581025-MayEagle Bend0008004Player 413444444545385555555544482693800082693880

## To Enter Players Into Sheet 2 As They Are Picked

Mar 3, 2008

I am starting a new Fantasy Football League. I am wanting to be able to enter players into Sheet 2 as they are picked. And I am wanting those picks to be simultaneously placed on Sheets 3-14 according to their position. Sheet 1 is a list of names according to positions. A more detailed explanantion is entered below.....

## Audit The Selection Of Players Selected

Mar 14, 2007

I have this macro and I would like to audit the selection of players selected. I would like the number that is entered in the input obx to be placed in the sheet "DRAFT" and be placed in A1 and the next in A2 and so on. Can this code be modified for this to occur.

Sub SearchDelete()
Dim ID, c As Range
ID = InputBox("Enter the Super10 Player ID Number", "Super10 Player Search")
If IsNumeric(ID) Then
With ActiveSheet.Range("a:a")
Set c = .Find(ID, LookIn:=xlValues)
If Cells(c.Row, 11).Value = "" Then
Msg = "P L A Y E R A L R E A D Y S E L E C T E D !" & vbCr & vbCr & "Player # : " & Cells(c.Row, 1).Value & vbCr & "Name : " & Cells(c.Row, 4).Value & vbCr & "Games : " & Cells(c.Row, 6).Value & vbCr & "Average : " & Cells(c.Row, 7).Value & vbCr & "Position : " & Cells(c.Row, 2).Value & vbCr & "Team : " & Cells(c.Row, 3).Value & vbCr & "Rank : " & Cells(c.Row, 27).Value & vbCr & "Rank POS : " & Cells(c.Row, 28).Value.............................

## How To Auto-move Players In Cup Tree Using Formulas

Aug 31, 2012

I am trying to build a cup tree that automaticly move players over to the next round if they are first or second in
their group of 4. What happens when first person have a result of lets say 33 and 2nd and 3d person have a result of 35 each and the 4th person 37? First person is easy but then there are 2 persons with the sam result and they play sudden death and we put in a 1 in the sd column for the winner and a 2 for the loser of the sudden death.

How do I make my formula figure that if they had the same result go look at the sd column?

Another thing is that of the 2 players advancing they have to be placed in the same order in next round, how can I achieve that?

If you look in column I row 19-22 there are players in the wrong order because the player with the better result goes in first. It should be this order: 9 11 15 16 instead. (if you are ahead in the previous round you will be ahead in the next round)

Another problem I noticed now is that when 2 players has the same lowest score the first player takes both spots as it is now and that doesn't work in real. You see what I mean if you look at player 1 in round 1 and 2 (R1 & R2), in this case it should have been players 1 2 6 and 7 moving on to round 2 and not 1 1 6 7 as it is at the moment.

(Rank is their rank from the qulification rounds where the first 4 is seeded and the rest is drawn into 1 group a time)

Klass B

*
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R

2
Rank
Name
R1
sd
Pl.

[Code] .......

Cell
Formula

I7
=IF('Klass B Calculations'!F4=1;'Klass B Calculations'!C4;IF('Klass B Calculations'!F5=1;'Klass B Calculations'!C5;
IF('Klass B Calculations'!F6=1;'Klass B Calculations'!C6;IF('Klass B Calculations'!F7=1;'Klass B Calculations'!C7;""))))

[Code] ..........

## Pair Of Digits In Col B

Nov 4, 2008

I have a pair of digits in col B, that I would like to match with the digits in in col D, and display those matches in col E. If possible I would delete the duplicates in col E, and show results in col F.

## Spreadsheet To Manage My Players In A Virtual Sports Game

Dec 13, 2007

I have been working on a spreadsheet to manage my players in a virtual sports game. I have worked out that the optimum skill scores for all the positions and want a way to compare a player to the optimum.

For example:

1st2nd3rd4th5th6th7th
Position 147.1737.6742.0533.8313.6711.3317.33

These are the averages for Position 1

How do I find the player who closest matches this optimum. Players have scores in the same 7 skill areas.

## Slaved Listbox Pair

Apr 23, 2007

I have two lists that represent pairs of electrical connectors. List_1 is Male Connectors, and List_2 is the mating Female Connectors. The lists are built so that when side-by-side, a mating pair line up next to each other.

I'm trying to build a User Interface that presents the connectors as pairs, but also aloow the user to select EITHER member of the pair.

My first thougt was to use a Listview or a Listbox with 2 columns. Either way, the user selects a full row, rather a single entry in a row.

I finally ended up building a userform with 2 Listboxes adjacent to each other, and a Vertical Scrollbar Control to the right of the pair. I added the following code to the form, to scroll both Listboxes simultaneously:

Private Const Display_Lines As Long = 7

Private Sub ListBox1_Click()

Me.ListBox2.ListIndex = -1

End Sub

As far as that goes, it works fairly well. The user scrolls up and down using the Scrollbar control, and paired entries remain adjacent to each other. The user can select an entry from either Listbox, and I can easily harvest that choice through code.

I was hoping, however, that I could support people who use the keyboard for navigation.

Focus on one of the Listboxes, then navigate using the up and down arrow keys. When the user gets to the end of the list, the value of the Scrollbar control increments or decrements as required, thus re-populating the lists. I just can't get this to work in a way that is not cludgey. I have worked through about a half-dozen possible methods, and each one has some hitch that makes it either hokey or unworkable.

## Rumble 3 Digits From Pair's

Dec 11, 2009

How to make Rumble 3 digits from pair's

Jun 2, 2007

I have used excel to create a list of matching pairs, which I want to link together. The problem is, all I have been able to create is a very long list of matching pairs, and no way to link all the pairs together. My sheet looks like this.

a b
1 100 200
2 200 300
3 300 400
4 300 500
5 600 700
6 800 700

The first row shows that 100 goes with 200, and the other rows continue defining which blocks go together. What I need is a way to summarize all the blocks that link up, ie get 100-200-300-400-500 and 600-700-800 from this list of relationships. Can't do it with a lookup because some blocks link to multiple other blocks.

## Tournament Spreadsheet (flexible Number Of Players And Payout Percentages)

May 10, 2014

I'm trying to figure out a simple spreadsheet that can spit out tournament payouts based on a flexible number of players (we might have 55, 60, 100) and flexible percentages based on the pot size (if we have 100 players, we would like to pay more players than if we had 50).

Something like [input number of players] [input pot size] [input # of payouts] [input percentage of each payout] it would just save a ton of time as we're trying to calculate payouts on the go.

## How To Pair / Concatenate Values Of First Column With Each Other

Feb 4, 2014

we want to add/concatenate the values of first column and show the result in next column. The problem is fully explained in the comment section of the sheet attached. But still if you are having in getting the problem

## Organize Data By Odd Number And Pair

Mar 16, 2014

I have list of county roads and would like to organize them by odd number and pair. Macro that can change the pair number first then the odd number here is an example

ORIGINAL LIST

[Code] ...........

## Pair Up Positive And Negative Numbers

Jan 5, 2009

************************************************************************>Microsoft Excel - Book2.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB2B3B4B5B6B7B8B9B10B11B12B13B14B15B16B17B18B19B20B21B22B23B24B25B26B27B28B29=ABCD1 amount Abs amtMark x when paried up 2             (43,746.73)43746.73x 3               43,746.73 43746.73x 4               43,746.73 43746.73  5             (60,579.30)60579.3  6             (60,579.30)60579.3x 7               60,579.30 60579.3x 8             (98,416.85)98416.85x 9               98,416.85 98416.85x 10               98,416.85 98416.85  11           (500,000.00)500000  12           (500,000.00)500000  13           (500,000.00)500000  14           (500,000.00)500000x 15             500,000.00 500000x 16           (700,000.00)700000  17           (700,000.00)700000  18           (700,000.00)700000x 19           (700,000.00)700000x 20           (700,000.00)700000x 21           (700,000.00)700000x 22           (700,000.00)700000x 23           (700,000.00)700000x 24             700,000.00 700000x 25             700,000.00 700000x 26             700,000.00 700000x 27             700,000.00 700000x 28             700,000.00 700000x 29             700,000.00 700000x Sheet1 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"> Hi everyone,

I can't figure out how to mark a "x" for the paired up figures in column A as shown in the above spreadsheet using a formula(e) and/or VBA. At the moment I'm doing this manually. Imagine doing this for thousands of line... once a week

## Calculate Players Ranking Based On Their Weight Categories And Attempts Total?

Jan 31, 2014

I am trying to calculate players ranking based on their weight categories and attempts total, e.g. Category (50kg, 69kg etc..) Rank should be calculated automatically the highest total value of cat. 50kg is 1st second highest is 2nd etc. However, if tow players or more within the same Category have scored same point ranking will be calculated based on Body Weight less comes first and if both have similar weight calculation will be based on Start # first player comes first etc..

Table:
Start #
Name
Body Weight
Team
Category
Total Point
Rank

1
Player #1
49.2
Team #1
50kg
75

## Remove Pair In Sheet1 If Exist In Sheet 2

Dec 22, 2009

I have two sheets of data: sheet1 and sheet2. Data in sheet 1 and sheet 2 are in pair, ex: row1 and row2 is 1 pair, row 3 and row 4 is one pair ect…I need a program that start from each pair in sheet1 and search for it in sheet2, if that pair already exist somewhere in sheet2, then cut that pair from sheet1 and paste it into sheet3.

## Combining Values To Create 2 Digit Pair?

Jan 17, 2013

In A1
01234

In B1:k1
01 02 03 04 12 13 14 23 24 34

I am looking for a formula that will combine each digit together as a 2 digit value

Is this even posible?

The value in A1 could range from a 3 to 9 digit value.

## VBA Code To Random Pair List Of Names

Oct 23, 2013

I want to create a simple worksheet that takes a list of names (All of the members of my family) and Randomly selects another name from that same list and matches them to it ( I don't want to say "paired" because I want each person to have a one way relationship to the other, in other words just because personA is matched to personB, i don't want personB to automatically be paired to personA) I hope that makes sense. Once every name on the list is matched with a person I would like to move that name to a database that I can track each year. The practical application of it is this: Each year our family randomly draws names and we are tasked to buy a new x-mas ornimate for that person, ideally you would not get the same person 2 years in a row, and the person that you have does not have you in return simply to add more variety and the database would track who had who each year.

Code:
Sub test()
Dim a, i As Long, temp, n As Long
a = Range("b2", Range("b" & Rows.Count).End(xlUp))
Randomize
With CreateObject("System.Collections.SortedList")
For i = 1 To UBound(a, 1)

[Code] ......

## Comparing 2 Column (pair) And Returning Count

May 30, 2014

Excel user that has been manually computing a 6000 row spreadsheet. Here is sample data and what I need. Column A goes through the alphabet (A,B, C, etc.) and Column B is numbers from 1-65. I need Column C to count the number of rows for each alphabet/number pair. K, 28 has 3 rows; K, 33 has 1 row; L, 21 has 4 rows; etc.

Column A
Column B
Column C

K
28
3

K
28
3

K
28
3

[code]....

## Given A List Of Numbers (ID) Pair Up (roundrobin) Without Duplicating

Mar 19, 2008

This is my Excel dilemma: creating roundrobin pairs.

For a given list of numbers, I need to generate pairs where each number is paired with all the other numbers without creating a duplicate pair.

For example: 1,3,4,6... (dynamic)

Pairs: 1-3, 1-4, 1-6, 3-4, 3-6, 4-6

Results should be generated in two columns. Column A would be ID1, Column B would be ID2 (the combination of both would be the pair created)

ID1ID2131416343646

I have basic ideas for a macro but the loop within a loop and the OFFSET for the next row is something I really can't put together.

## Compare And Pair Rows Within Tolerance Range

Apr 8, 2008

I have an unknown number of rows that represent parts and 6 columns that represent part dimensions. I need to find and output matching pairs of parts that are within certain dimensional tolerance ranges.

For example:
Dimension 1 Dimension 2 to Dimension 6
Part 1
Part 2
to Part X

-I would need the code to check if Dimension 1 of Parts 1 & 2 were within a certain range and if Dimension 2 of Parts 1 & 2 were within a range etc. then (if all of them were true) output them as a pair. Otherwise, it would continue to search for paired parts. Once a pair is found, those parts can't be used again. How can I do this?

## Keeping Track Of Scores And Automatically Displays Names Of Players In Descending Order?

Feb 7, 2012

I'm fairly new to using excel and have been trying to create a simple spreadsheet that keeps track of scores and automatically displays the names of the players in descending order. Anyway I have gotten to the point of using hookup to match a value and return that players name. But when two players have the same score it will only return the first found value. I sort the number scores using a LARGE function and it works great. Then I use something like this =HLOOKUP(Y2,B27:K28,2,FALSE) to match that value with the players name. How to return the other players name when the scores are the same?

## Some Entries Are Not Give The Exact Matching Pair But One Upper

Mar 14, 2009

I am having a problem in using lookup formula. Unfortunately for some entries it does not give the exact matching pair but one upper. I have attached the excel sheet. Please correct me where is the mistake. More about the sheet:

One column contains the alphabets from a certain language and second column contains corresponding unicodes. I want to search the unicode of a particulat alphabet using "lookup". Cell C4 is the key value. D4 uses lookup to get unicode value

## Pivot Table: Associate With Each Pair Of Code And Customer

Feb 1, 2007

I have a master worksheet that contains a lot of datas. Example below:

Invoice # Code Customer Money
1 1101 a 10
2 1102 a 20
3 1102 b 30
4 1103 c 40
5 1104 d 50
6 1101 a 60
7 1103 c 70

After creating a pivot table with code, customer as Row and money as Data, I get this:

Sum of money
Code Customer Total
1101 a 70
a Total 70
1102 a 20
a Total 20
b 30
b Total 30
1103 c 110
c Total 110
1104 d 50
d Total 50
Grand Total 150

Suppose now, I have another data named Rate that I need to associate with each pair of Code and Customer. See below:

Sum of money
Code Customer Total Rate..................

## Randomly Add Name To 5 Out Of 6 Boxes?

Feb 23, 2012

I have made a calendar in excel, and need to make the following work.

I have six boxes (each for one day of the week, excl. Sunday) and a separate box containing names. I need to come up with a way that excel will automatically add those names to any five of the six boxes at random (always leaving exactly one box free for each name), and always choose which box at random.

## Ranking Greater Than "0": Able To Rank Players Only If They Meet Or Exceed A Specific Number Of Rounds

May 26, 2009

I want to be able to rank players only if they meet or exceed a specific number of rounds. I have been able to get close but I would like to have the ranking start at "1" instead of "0" (see sheet).