'Random' category
Subcategories
How to generate a round-robin tournament
This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]
This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]
How to build a Team Generator – different number of people per team
JD asks in this post:Â Dynamic team generator Hi, what if we have different number of people per team? So in […]
JD asks in this post:Â Dynamic team generator Hi, what if we have different number of people per team? So in […]
Assign records unique random text strings
This article demonstrates a formula that distributes given text strings randomly across records in any given day meaning they may […]
This article demonstrates a formula that distributes given text strings randomly across records in any given day meaning they may […]
How to create random numbers, text strings, dates and time values
The RAND() function In Excel returns a number greater than or equal to 0 (zero) and less than 1. Combining […]
The RAND() function In Excel returns a number greater than or equal to 0 (zero) and less than 1. Combining […]
True round-robin tournament
Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]
Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]
Create a random playlist
This article describes how to create a random playlist based on a given number of teams using an array formula. […]
This article describes how to create a random playlist based on a given number of teams using an array formula. […]
Team Generator
Table of Contents Team Generator Dynamic team generator 1. Team Generator This section describes how to create teams randomly. There […]
Table of Contents Team Generator Dynamic team generator 1. Team Generator This section describes how to create teams randomly. There […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values