Hi all,
I have a spreadsheet that looks a little like this:
Header 1 Header 2 Header 3 Header 4 X A 1 x X A 1 y X A 2 x X A 2 y X B 1 x X B 1 y Y A 1 x
I'm looking to do some funky data validation where there is a drop-down list for each header, and in each of those drop-down lists are the unique values in that header's column, but where each list is only those values that occur based on the previous list.
So for the above example, list 1 is 'X or Y'; select X, then list 2 becomes 'A or B'; select A and list 3 is '1 or 2' - if you select B list 3 is '1' only. And so on...
Now I can do this with a whole load of manual name management, creation of tables which only have unique values etc. - but in my actual spreadsheet, I've got about 160 unique values for Header 3 and 7,500 for Header 4, so that's looking like a daunting task.
So I'm hoping you fine folks on this forum will be able to help - is it possible to make dependent drop-down lists based off a single table with only unique values shown?
I'm on excel 2016, so don't have access to the newest functions, but will happily use Macros if that makes life simpler.
Many thanks!
T.
Edit: added an attached sample spreadsheet - the table is what I'm looking to validate, and I've put in example boxes showing a possible flow through the 4 drop-down lists.
Bookmarks