Maybe a hard to explain title, an example:
A list of products, with a value per year:
<tbody>
</tbody>
I'm searching for a solution to have a Data Validation List (Or filtered name range) of products with a non empty value in 2019 (so in the example: Pear Orange and Coconut) as selectable items in a data validation drop down list (in another cell).
List must be dynamic, when add a value under 2019 for Apple, Apple must be part of the list as well.
Seems not a difficult question but can't find any related question or example which i can use to compose my own formula or procedure.
Thanks for helping me out.
Marcel Houkes
A list of products, with a value per year:
A | B | C | |
1 | Product | 2018 | 2019 |
2 | Apple | 10 | |
3 | Pear | 8 | 9 |
4 | Melon | 12 | |
5 | Orange | 4 | 5 |
6 | Lemon | 2 | |
7 | Coconut | 11 | 12 |
<tbody>
</tbody>
I'm searching for a solution to have a Data Validation List (Or filtered name range) of products with a non empty value in 2019 (so in the example: Pear Orange and Coconut) as selectable items in a data validation drop down list (in another cell).
List must be dynamic, when add a value under 2019 for Apple, Apple must be part of the list as well.
Seems not a difficult question but can't find any related question or example which i can use to compose my own formula or procedure.
Thanks for helping me out.
Marcel Houkes