Forum Discussion
Lista desplegabe
Salvador_2703 To create the dynamic range in the traditional way, please follow the instructions in the link below:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/create-dynamic-defined-range
But if you insist on using the ADDRESS function, you would have to select a character for the last entry in your list (can not be a blank). Say, that character is a hyphen "-", then enter this formula as the source for the Data Validation list.
=INDIRECT("$A$1:"&ADDRESS(MATCH(1,FIND("-",A:A,1),0),1))There are many other ways to achieve similar results.
Salvador_2703 To create the dynamic range in the traditional way, please follow the instructions in the link below:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/create-dynamic-defined-range
But if you insist on using the ADDRESS function, you would have to select a character for the last entry in your list (can not be a blank). Say, that character is a hyphen "-", then enter this formula as the source for the Data Validation list.
=INDIRECT("$A$1:"&ADDRESS(MATCH(1,FIND("-",A:A,1),0),1))There are many other ways to achieve similar results.
Riny_van_Eekelen
Thank you very much, it worked great for me.
