How to use the RANDBETWEEN function
What is the RANDBETWEEN function? Returns a random whole number between the numbers you specify. This function is volatile meaning […]

Rotating unique groups with no repeat
This article demonstrates a formula What's on this page Question Formula Array formula Explaining array formula Get the Excel File […]

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 […]

Working with classic ciphers in Excel
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

How to generate random numbers and text
Microsoft Excel has three useful functions for generating random numbers, the RAND, RANDBETWEEN, and the RANDARRAY functions. The RAND function […]

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 […]

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 […]

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 […]

Create a random playlist
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 […]