CODEWITHSUNDEEP
excelgoogle-sheetsformattingdata-analysis
OLUWAFEMI AYOOLA
OLUWAFEMI AYOOLA

Reputation: 11

Using Randbetween With Conditions In Excel

My worksheet screenshot

A round-robin schedule generated with even distribution of each of 21 teams playing approximately equal games in 14 given locations (no less than 1 game in each location, no more than 3 for each team).

The end product will be a table with Week, Home Team, Away Team, Location Home vs Away balance is not important, I have a template with everything populated except the location.

Any condition I could add?

=RANDBETWEEN(1,14)

Upvotes: 1

Views: 144

Answers (1)

SIE_Vict0ria
SIE_Vict0ria

Reputation: 194

Try using the solver add-in, which is designed specially to solve logical models such as this.

https://www.excel-easy.com/data-analysis/solver.html

Upvotes: 1

Related Questions