Forum Discussion
Help with formula
Hello, I am trying to remove the blank selections from a dependent drop list I have created in Excel and I am having a hard time figuring out what the formula would be to get this accomplished. A li...
H1D3F if anyone was curious, this is the formula I used in data validation to get all the blank spaces in my drop down list gone except for one. =OFFSET(Sheet1!$A$2:$EO$63,0,MATCH($A$5,Sheet1!$A$1:$EO$1,0)-1,COUNTA(OFFSET(Sheet1!$A$1,0,MATCH($A$5,Sheet1!$A$1:$EO$1,0)-1,65,1)),1)
if you used the formula I have provided in sample file please mark the answer as best solutuion...
