Determine is Row is Odd or Even then insert value in next Row

[bradshk]

Hi All,

Im working on a spreadsheet to use on RoundRobin Pool Tournaments. I found a VBA script on here that does mostly what I need but Im having a problem with the input list. It needs a list of names for the random generator VBA script. When the list of names are an EVEN number the scripts runs fine and creates the random pairs. When it's an Odd number of names it has issues and does not create the pairs. Full disclosure, Im not anywhere near a VBA expert so Im just working my way thru it. In order to work with the existing script, I need to determine if the number of players in the list (Column A) is and odd number. If Yes it's an Odd number, then I need to automatically enter "Bye" into the next cell to make it an even number of pairs (one player pairs up with Bye will sit out that round). The list of names is dynamic as the tournament progresses and players drop out. Any thoughts on how I can do this with formulas on Column B? If I need to use A VBA script I can go that route but thought formulas woudl be easier for me to maintain. Thanks for any input.

 

[Joe4]

Have you had a look at the ISODD and ISEVEN functions?

 

[steve the fish]

Why do players drop out in a round robin? Just each player plays every other player isnt it? We would need to know where the player list is housed.

 

[bradshk]

Why do players drop out in a round robin? Just each player plays every other player isnt it? We would need to know where the player list is housed.

The players are given a number of allowed losses for the tournament based on their skill level. It's a handicap system. So in any given round a player or more can drop out. The player list in the screenshot example is Row A (Nine players) which is dynamic based on the user still having a number of losses greater than Zero.

 

[steve the fish]

So to write a formula we would need to know how the player list is setup and the rules of why you use a player or dont. Presume your player list is already randomised based on your provided formulas. Basically we need to be able to count the number of eligible players and then if odd make the last 'player' bye.

 

[bradshk]

The players are given a number of allowed losses for the tournament based on their skill level. It's a handicap system. So in any given round a player or more can drop out. The player list in the screenshot example is Row A (Nine players) which is dynamic based on the user still having a number of losses greater than Zero.

Correction,

Row B (Nine players)