How to Create SMART Drop Down Lists in Excel

preview_player
Показать описание
How to use a formula to create an Smart Drop down that changes based on a previous choice you have made.

If you like this video check out my channel at:

Check out my other videos on

If you are interested in full day session on any Microsoft Office products check out my website at

Let's Connect on Social Media

Рекомендации по теме
Комментарии
Автор

Great video and great tip and not a very well known one either so top choice!

askmrswatson
Автор

IS there a way of doing this without using named areas as I want to use 2 words in the dropdown

terryjones