✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
One of the most helpful questions in data validation is how we can have a validation list that automatically increases in size each time we add new items to the list. The default way in which the validation lists work is to have a fixed list, and the interesting thing is that this list is not fixed, but dynamic.
Sure you can be interested in these tutorials Validation of data in Excel: • Validación de datos en...
3 ways to have self-adjusting validation lists
As I said in the introduction, the interesting thing about validation lists is when we discover how to have dynamic lists, that is, they automatically adapt to the size of the data. In this tutorial we will see 3 ways in which we can achieve self-adjusting validation lists:
Using the DESREF function.
Using defined names.
Values from a Table.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
Негізгі бет Dynamic data validation list in Excel drop down list @EXCELeINFO
Пікірлер: 58