Cascading drop-down data validation lists with only unique items.

Another Jon

New Member
Joined
Nov 5, 2017
Messages
3
Here is a gross over-simplification of my dataset in Excel (it's larger and more purposeful than this). It's in a table, at this point with quite a few more columns and vastly more rows.


File-Copy-icon.png

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">**Type**,**Creator**,**Name**,**Characteristic**
Animal,Frankenstein,Cat,Aloof
Animal,Frankenstein,Dog,Awoof
Animal,David Warner,Newt,Slimy
Animal,David Warner,Slug,Slimy
Not_Animal,David Warmer,Laster,Pew-Pew
Not_Animal,David Warner,Computer,Calculon
Not_Animal,No One,Nothingness,Void</code>


Wihin excel, I am trying to make cascading lists that are driving me a bit mad.

I need to present only the unique values in each cascading drop-down list.

For instance, Choice 1 would be "Animal or Not_Animal" derived from Type. Assuming a user chose "Animal", the next drop down he would be presented with "Frankenstein" or "David Warner", not "No One". Finally, on a third drop-down if he previously "Frankenstein", he could choose "Dog" or "Cat" and would not see "Laser", "Computer", nor "Nothingness". And I'd autopopulate the other another cel with the Characteristic.

I'm struggling to derive the unique options, Animal or Not_Animal, followed by the subsequent unique data set to present to the user. I've been mostly working with Names and Formulas, and, considering nothing has come close to working, I don't know if it's worth cluttering this message with my abysmal failures.

I can certainly get Type into a pivot table of unique values, and the same for Creator. I can reference Type into a list, but can't seem to get a correlation between Creator to go with it (it comes up empty), using =INDIRECT and simply the name of a function I created.

Thanks for any help!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top