Struggling to obtain unique items in drop-down boxes

Hello, I am new here and hoping somebody can help me with a problem or two - and these may be the first of many!

Basically I have 3 drop down lists (combo boxes) on my first worksheet. They are category, sub category and then a selection of options in the 3rd box which are based on the selections of the first two, so these are dynamic drop downs.

I am using the "Name Manager" to name lists of data that the drop down boxes will reference with the following code:

Please Login or Register  to view this content.

Each of the "options" for ComboBox1 are fine, because they will be unique and I can just use a ListFillRange to reference the cells containing this information.

However, there will be duplicate sub categories because there will be multiple entries under each option but I have no idea how to make these entries unique when using a dynamic drop down? Obviously if I was just using the ListFillRange, I'd be able to remove the duplicates, but if I use this then I can't make the results of ComboBox2 dependent on what's been selected in ComboBox1.

Another thing is, because I am using the Name Manager, my combo boxes will show the name of the list, because this has to match up. So because I can't use spaces in the Name Manager, I have to name them Option_1, Option_2, etc. and it looks really untidy. Is there a better way of doing dynamic combo boxes so that I can avoid this?

Please bear in mind I am an Excel novice so the above might not make much sense, and if there's any thing I've missed then just let me know, but I'd be so so grateful if somebody could offer some advice on these issues.

Many thanks,

Hello alex_ncfc,

Welcome to the Forum!

It would help if you could a post sample workbook. It will make it easier to follow what you are doing and ensure suggestions and solutions pertain your desired goal.

Hello alex_ncfc,


To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.