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!!