Channel: TeachExcel

Category: Education

Tags: ignore blanks data validation listdata validation excelremove blanks excel

Description: Excel File: teachexcel.com/excel-tutorial/ignore-blanks-in-a-data-validation-list-in-excel_1302.html?nav=yt Excel Courses: teachexcel.com/premium-courses/?src=youtube_v_n7s7-_VrKn4 4 ways to remove blanks from Data Validation lists in Excel - including a formula to use for Excel 365 and one formula for older versions of Excel. This tutorial covers multiple methods for blank or empty cell removal so that you can pick the one that either works best for you or is easiest for you to remember. You will learn how to use new dynamic array functions for Excel 365 as well and the spill features and pound sign, and also how to use the older clunky arrays for Excel. NOTE: To use the older formula from this tutorial, you must input it using CTRL + SHIFT + ENTER or it won't work - this is because it is an array formula. Other Resources: Data Validation List Blanks (msft): answers.microsoft.com/en-us/msoffice/forum/all/data-validation-list-of-unique-auto-sort-no-blanks/e8b08cdd-bb13-44f1-8775-d835a04ff191 Filter Function Tutorial: youtube.com/watch?v=u96imqGMBDM Excel Courses: - VBA/Macro Course: teachexcel.com/vba-course-update.php - Building Professional Forms: teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_n7s7-_VrKn4 - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_n7s7-_VrKn4 TeachExcel.com #msexcel #howto #tutorial