As I am revising my excel template for Retail Inventory, I realized there might be some people out there needing help or guide on how to use a dynamic dropdown, but do not want to include the blanks. Sample Problem Description 1: I want to make a dropdown list in excel using Setup!$C$15:$C$44 range butContinue reading “How to do Dynamic Dropdown without blanks in Excel step by step guide”