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 all Excel versions which is by using INDEX, MATCH and SMALL functions, and another solution that is compatible with Office 365/ Excel 2021 by using the SORTBY function

00:00 Introduction
00:41 All versions solution
05:55 Excel 365 Solution

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