The COUNTA function counts the number of cells that are not empty in a range. We learnt in our previous tip that the OFFSET function is used for creating dynamic data ranges. However, in this tip we show you how to create a dynamic drop down list by using Data Validation, OFFSET and COUNTA functions. We have written tips on how to create a static and dynamic drop down list using and the Table option. With a dynamic drop down list, when you delete or add months the list changes to accommodate that action, whereas a normal list does not. Let’s say you have a list where you are likely to add or remove values, a dynamic drop down would be the best option to select data. A dynamic drop down list in Microsoft® Excel® is a convenient way of selecting data without making changes to the source.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |