Exclude Blanks from Excel Drop Down List #shorts
Channel: Essential Excel
Date: 2022-12-09

How to Exclude Blanks from #Excel Drop Down List

In this tutorial we demonstrate how to use FILTER function to exclude blanks form your list and only present values in your drop down list.

For more Excel tips, tricks and tutorials don't forget to subscribe to  @EssentialExcel channel.

Website: https://bathompsonltd.com/

Our other social accounts:

Instagram:https://www.instagram.com/essentialexcel
TikTok: https://www.tiktok.com/@essentialexcel
LinkedIn: https://www.linkedin.com/company/essential-excel/

Instructor Lead Excel Course ► https://essentialexceluk.com/products/master-excel-course

More Tutorials ► https://youtube.com/EssentialExcel

#dropdownlists #exceldatavalidation #datavalidation #dropdown #dropdownmenu #dropdownlist #exceltutorial #exceltips #dynamicdropdown #excel #dropdownwithoutblanks #dropdownignoreblanks