I have a drop-down list that refers to list of information that is not always
going to have values in every cell in the range/list. I need to know how to
set up the drop down so that it only returns values and ignores the blank
cells in the range.