How to Create Multiple Drop Down Lists In Excel Without Repetition

Sometimes it is needed to show an option in a drop-down only when it has not been selected already. For example, assigning meeting roles or splitting teams. Excel in-built drop-down list feature cannot do this.

In this video tutorial, I will show you how to create multiple drop downs in Excel where there is no repetition. This means that when an option has been selected, it does not appear in other drop downs.

Read the tutorial and Download the Example File:
https://trumpexcel.com/multiple-drop-down-lists-in-excel/


Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Видео How to Create Multiple Drop Down Lists In Excel Without Repetition канала TrumpExcel