Randomize a list with RAND function Users of any Excel version can randomly sort their original dataset by using the RAND function with the help of the Sort feature, please follow the steps below. Step 1: Enter the RAND formula Select the cell next to the top cell of the list you will ...
The final result is a random number between 1 and 100, which is then printed in the Immediate Window using the ‘Debug.Print’ method. Example 2: Randomly selecting a name from a list If you have a list of names in a worksheet, you can use the Randomize statement to select a random ...