Auto Populate Dependent Drop Down List if there is only one answer

**simple?** · 08-13-2013, 04:07 PM

Hi,
I created a dependant drop down list. I would like any selections with only one value to choose from to fill in automatically, and the cells with multiple selections available to show blank (Dropdown arrow), until the dropdown is picked.

Example:
Excel Drop Down.jpg
I set up a table which I then made into a pivot table. Based on the pivot table I changed the names of the "Category" to match the "Name" associated with it in the name box. I then made a dependent dropdown (Column F) =INDIRECT(E2) to get my answers.

However, only two names of the 5 have more than one answer to choose from. Is there a way to have the dropdowns with only one value to autopopulate to that value?

Such as if the Name Derek was picked, I would want Green to be selected, so that I would not have to push the dropdown and pick myself. I am working with a huge amount of data so I want to be able to make this quicker, or less complicated.
Excel Drop Down 1.png

My list will be continuously growing, so I will need this fix to carry down the whole column.

The real purpose of this is to cateforize a large list of companies, and arrange them based off an initial list to the category that they are currently working on. Sometimes a company will work on only one category, and other companies might work 3-6 different categories. How can I configure this so that I only need to choose the category for the companies that are working in multiple categories?

I hope I explained my issue enough. If anything isn't clear, let me know.

Thanks for your help!

**protonLeah** · 08-13-2013, 05:06 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread

To attach a Workbook
(please do not post pictures of worksheets)

**FDibbins** · 08-13-2013, 05:27 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.