PDA

View Full Version : Create a combobox



ddesantis
09-27-2014, 06:04 AM
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
09-27-2014, 06:14 AM
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