Select RANDOM VALUES FROM LIST in EXCEL - NO DUPLICATES

In this video, we show how to select random values from a list in Excel without duplicates.
We show a solution that's compatible with Office 365/ Excel 2021 by using the SORTBY function.

If you would like to see a solution compatible with all excel versions, check the first comment.
Download Example files:
https://tinyurl.com/h2wpdfn8

Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd

Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9

*****My online Excel Courses*****
https://www.excelbonanza.com/courses/

#random #indexmatch #sortby

Видео Select RANDOM VALUES FROM LIST in EXCEL - NO DUPLICATES канала Excel Bonanza