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

Тәжірибелік нұсқаулар және стиль

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
    @alexmason25955 ай бұрын

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

  • @IvanCortinas_ES
    @IvanCortinas_ES Жыл бұрын

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

  • @lethabo_0334
    @lethabo_0334 Жыл бұрын

    Fantastic stuff!!

  • @danial.amirian
    @danial.amirian11 ай бұрын

    Amazing, thanks a lot 🙏

  • @dinapr4531
    @dinapr453110 ай бұрын

    Thankl you so much... You saved me.

  • @steveh1620
    @steveh1620 Жыл бұрын

    I have searched the internet and KZread 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
    @casst346 Жыл бұрын

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

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

    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
    @ambientartvibes8 ай бұрын

    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??

  • @rickzzy3049
    @rickzzy3049 Жыл бұрын

    How about for old version of excel..

Келесі