Combo Box Input Range - Removing Duplicates

[ccooper]

Hi

I am struggling to find a way to do what I think (??) should be a very simple option with combo boxes.

The input range for my combo box contains many duplicates (as I am trying to run a combo box from a data dump rather than having to type a seperate list for the input range every time), I would like the drop down list on the combo box to just display one of each option (i.e like when you autofilter you only see each option once).


Any suggestions????

Thanks!!

[tigeravatar]

ccooper,

Is your combobox on the worksheet as an activex control or form control? Or is your combobox on a userform?
Also, you could make a dynamic named range for the column containing duplicates, and then use that in a formula to remove duplicates, and then have another dynamic named range on the formula results, and use that dynamic named range of uniques as the combobox's input range.