👉HOW TO CREATE DYNAMIC DROP-DOWN LIST THAT EXCLUDES EMPTY CELLS
The dynamic drop-down list that excludes empty cells ensures that new input on the database updates itself automatically on the drop-down list.
Work along to gain hands-on experience on the data validation feature in Excel.
Will be glad to get your feedback in the comment section of this video. It's important you know that I read all comment and will definitely reply.
Use the SUBSCRIBE button and notification bell 🔔 to get a prompt notification on all my videos on this channel
Use the link below to JOIN our community of Smart Excel Users Network 👇
/ smart. .
Social Platforms:
Subscribe to YouTube: http://bit.ly/AccountingandExcelVila
Facebook: http://bit.ly/SmartExcelUsersNetwork
YouTube: http://bit.ly/amakaifebunandu-youtube
LinkedIn: / amakaifeb. .
Twitter: / amaka_ifebunadu
Instagram: / amakaifebunandu
#DataValidation
#OFFSETFunction
#COUNTAFunction
#ExcelFormulas
#Drop-downList