Create a combobox

[ddesantis]

Hi,

I would like to create a combo box in cell D2 that shows value in range B2:B50000, without duplicate.

I'm a beginner so I tryed with tutorials but no luck!

[ddesantis]

actually, I don't know if the combo box is the right thing.

To make it simpler it's a data filter,but instead of having it in cell B1 and filter cell B2:B50000, I want this data filter in cell D1 and filter (without showing duplicates) cell B2:B50000