Unique Random Number Generator in Excel - No Duplicates

Unique Random Number Generator in Excel - No Duplicates | Randomly Select Names in Excel

Рет қаралды 24,034

Күн бұрын

Download the featured file here: www.bluepecantraining.com/wp-...
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
------------------------

Пікірлер: 10

@alexmason2595 4 ай бұрын

Literal life saver, the only video which fixed my issue with the "unique" function not providing the amount of results I want.

@IvanCortinas_ES Жыл бұрын

Excellent tutotial. Very useful the RANDARRAY function. Thank you Chester!!!

@lethabo_0334 Жыл бұрын

Fantastic stuff!!

@danial.amirian 10 ай бұрын

Amazing, thanks a lot 🙏

@dinapr4531 9 ай бұрын

Thankl you so much... You saved me.

@steveh1620 11 ай бұрын

I have searched the internet and KZfaq to find a formula that will pair numbers without repeat over several columns. This is the closest I have found but only for one time. I want to have for example 20 teams (that would be my column 1 through 20) play over 12 weeks (that would be my rows, week 1 through 12). Using 20 as the example I know that there are 190 possibilities of teams playing without meeting each other again during the season. I have not figured out how to get this into an array.

@casst346 Жыл бұрын

ok..how do you get it to list ALL possible 8 number combos?

@mungunbayar.bat-ochir 11 ай бұрын

take can be also used instead of sequence and index =LET( min;B2; max;B3; size;B4; population;max-min+1; is_valid;AND(max>=min+1;population>=size); result;IF( is_valid; TAKE(UNIQUE(RANDARRAY(size^2;;min;max;TRUE));size); "invalid input"); result )

@ambientartvibes 7 ай бұрын

I got this formula ''=INDEX(UNIQUE(RANDARRAY(B2^2,1,B3,B4,TRUE)),SEQUENCE(B2))''from your file, but it only work in rows. How to make it work in columns format??