I am needing to create a list in Excel from one column in sheet 1 that will make up the list in a different column. The problem I have is that the 1st column(that will populate the list) may have the same entry in it several times along with several distinct entries. I dont wont to show duplicates or any blank cells in the list box. In VB I would just write a Select Distinct statement but in Excel I am not sure how this is done.

Can some one point me in the right direction?

Thanks,

Jason