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
