The source of your Data Validation list contains blank cells and you don’t want those blanks to appear in the dropdown. Back
Fred used Data Validation to select a Model from his list. Once the model is selected, how would he pull all of the Back
Ingredients: 1 Mike Girvin; 1 Bill Jelen; Numerous ‘Fun’ctions and Formulas!
Mike has A New Book, A New DVD and Good Fun Dueling!
PowerPivot, The LOOKUP Function and MrExcel to The Rescue!