A drop-down box will return a complete list (including all of the duplicates). The values in the column have many duplications, and I simply want the combo box to return a unique list.Īfter trying this using various options like drop-down boxes, combo boxes etc it does not seem to work.
I need to create a drop-down (or a combo list) list based on a column in a separate worksheet (in the same workbook).
Hi All, first post here and have already used the search for some valuable advice and hope someone can be kind enough to help with the following:
