Generate unique random numbers

Selecting a subset of values from a larger set, or generating a random order of elements in a set, used to be difficult in Excel. In this movie, I’ll show you how to use new functions such as RANDARRAY and TAKE to create a list of randomly selected items from a larger collection. If you need to create a random order of all elements, just set the number of items taken to the number in the whole set.

You can download the sample file from http://www.curtisfrye.com/Unique_Random_Values.xlsx

If you’d like to support my work here, please buy me a coffee or two through Ko-fi!
https://ko-fi.com/technologyandsociety

Видео Generate unique random numbers канала Curt Frye