Create reducing data validation in excel | Shrinking data validation or drop down lists in excel
In this video, we show how to create reducing data validation lists in excel, which is also known as shrinking data validation or shrinking drop down list in excel. We do that with the use of dynamic array formulas, namely the FILTER and SORT functions.
Learn COUNTIF & SUMIF:
• Excel SUMIF SUMIFS COUNTIF COUNTIFS -...
Download Example files:
https://tinyurl.com/5n8sjaub
GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)
https://tinyurl.com/4ayp2457
Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd
****My online Excel Courses****
https://www.excelbonanza.com/courses/
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
#datavalidation #filterfunction
