Forum Discussion
Lista desplegabe
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.
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.
2 Replies
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.
