Max,

I like your idea with the C1 and D1 and it works well. However, if I
have a list of say, six elements like above but one element is blank,
the DV list now shows the five non-blank elements and then a #NUM!
error. If I have seven elements two of which are non-blank and non-
consecutive, then the DV list displays the five non-blank and then two
#NUM! errors. Anyway to remove those #NUM! errors?

Thanks,
D