Hi and thanks in advance,
I am trying to set up 2 Excel dropdown lists, one dependent on the other, using formulas if possible. I have looked over a lot of suggestions on the web but not found exactly the scenario I need.
Here is an example of the data the lists will be based on:
...
So the 1st dropdown list contains the years: 2018, 2019, 2020
When a year is selected in the 1st dropdown list, it should load the 2nd dropdown list with all the countries that have a value in the selected year column.
For instance, if 2018 was selected in the 1st dropdown list then load the following countries in the 2nd dropdown list: Australia, Switzerland, Norway
When the user makes a selection in the 1st dropdown list I would also like to clear any visible value in the 2nd dropdown llst.
Thanks again
Deutz
I am trying to set up 2 Excel dropdown lists, one dependent on the other, using formulas if possible. I have looked over a lot of suggestions on the web but not found exactly the scenario I need.
Here is an example of the data the lists will be based on:
Country | Year: | 2018 | 2019 | 2020 |
Australia | 1 | 2 | 3 | |
Czech Republic | 88.12 | 14 | ||
Venezuala | 7 | |||
Switzerland | 2.2 | 44 | ||
Norway | 3.45 | 55 | ||
USA | 100 |
So the 1st dropdown list contains the years: 2018, 2019, 2020
When a year is selected in the 1st dropdown list, it should load the 2nd dropdown list with all the countries that have a value in the selected year column.
For instance, if 2018 was selected in the 1st dropdown list then load the following countries in the 2nd dropdown list: Australia, Switzerland, Norway
When the user makes a selection in the 1st dropdown list I would also like to clear any visible value in the 2nd dropdown llst.
Thanks again
Deutz