Summary of Lista Desplegable AUTOCOMPLETABLE en EXCEL (SIN MACROS!!)

00:00:00 - 00:20:00

This video explains how to use the "hallar" function in Excel to find a specific word or phrase within a list. He shows how to use the function in various scenarios, and then goes on to explain how the function can be used to find text in a range of positions.

• 00:00:00 In this video, the author demonstrates how to use the "hallar" function in Excel to find a specific word or phrase within a list. He shows how to use the function in various scenarios, and then goes on to explain how the function can be used to find text in a range of positions.
• 00:05:00 This video explains how to use the AUTOCOMPLETABLE function in Excel. The function allows you to change the error message generated by an equation to another value. It can be used to change the error message generated by a function, as in the example above.
• 00:10:00 This video explains how to use a function called "filtrar" in Excel. The function filters a list of data based on a condition. For example, if you want to filter out all of the products with a nonexistent existence, you would use the "filtrar" function with the "existencia" parameter set to "0."
• 00:15:00 In this video, the presenter demonstrates how to create a list of available autocompleteable Excel functions. The list can be filtered by "true" or "false" depending on whether the column in which the function is being searched is included in the filter. The list also includes a list of adapters, which are items that are not autocompleteable but have a female or male version. Finally, the presenter demonstrates how to use the list to find a specific cable.
• 00:20:00 This video demonstrates how to create an auto-completeable list in Excel using macros. Once you have created the list, you will be able to hide the columns that were used to help with the auxillary mind and be done. I have also included a link in the description of the video so that you can download the list and put it to practice. Remember to give the bell a ring in all of your videos to receive notifications and don't lose any of your videos. I hope you enjoyed this video as much as I did. Take care.