Excel trick- Create a dropdown list dependent on another dropdown list with UNIQUE, FILTER and SORT

Описание к видео Excel trick- Create a dropdown list dependent on another dropdown list with UNIQUE, FILTER and SORT

While working with Excel, you might have come across a fantastic tool that allows you to create dropdown lists. It's clear and relatively easy to navigate on its own. But how do you achieve advanced functionality that lets you create dropdown lists dependent on the selection from another list? 📊🔗

In this tutorial, you'll learn how to use modern array functions in Excel – SORT, FILTER, UNIQUE – and leverage them to build dependent dropdown lists. At the same time, I'll show you why you shouldn't fear the #SPILL error. 🔄🔍

Remember to subscribe to the channel for more tricks and tips! ✅🔔

Комментарии

Информация по комментариям в разработке

Похожие видео