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

Подписаться 100 тыс.

Просмотров 24 тыс.

50% 1

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

Хобби

Опубликовано:

7 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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 RU-vid 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?

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

@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 )