Lista desplegabe

[Salvador_2703]

Hola, quiero agregar una condicional al rango de una lista desplegable que parta de la segunda hoja en A1 y que termine el la celda indicada por =DIRECCION(COINCIDIR("",A:A,0),1) que es el fin de la lista, no sé si sea posible, ojala me pueda orientar para saber si es o no posible.

Muchas gracias de antemano.

[#2 · Accepted solution]

@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.

[#3]

@Riny_van_Eekelen 
Thank you very much, it worked great for me.