Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/08/Random-Numbers-No-Duplicates.xlsx

In this video I demonstrate how to generate a list of random numbers containing no duplicates. This might be useful if you want to select a name or names at random from a list or at random choose a particular test result.

I demonstrate methods for Excel 365 users as well as for older versions of Excel.

00:00 Introduction
00:11 Excel 365 solution for creating a list of random, unique values
03:08 Select names at random in Excel 365
04:05 Solution for older versions of Excel
------------------------