Hmm?
Not sure that your formula removes blanks, if this gives the correct result with a list that includes blanks, it might well just be by coincidence.
See if this work book gives you some ideas, without a sample workbook it is difficult to see what you are really trying to do.
Names "Full_List"
Refers to:=
Then in E5
Drag/Fill Down to the end of Column D
Then Data Validation in say G5
Data > Data Validation Allow:= List
Source:=
Or Create a second name "No_Duplicates"
Refers to:=
Then Data Validation in say I5
Data > Data Validation Allow:= List
Source:=
Not sure if it will solve your particular problem but it might give you a start.
Bookmarks