Fix Data And Large Data How To Validation With Multiple Column. I am then using the offset function and a named range to get a data validation list that auto updates when i add something to the bottom of the list. Data validation is a method for checking the accuracy and quality of your data typically performed prior to importing and processing.
In the source box type the items of your excel validation list separated by commas. A while back we learnt how to make dynamic data validation lists based on excel tables that grow as the base data grow. For example to limit the user input to three choices type yes no n a.
A simple data validation list helps us display specific data range in the form of drop down list in a desired cell.
It can also be considered a form of data cleansing data. I am then using index and match to find the names of the top 15 values column 2. Suppose your data is in b2 to b10 continuously it can be easily mapped fr the list validation. A while back we learnt how to make dynamic data validation lists based on excel tables that grow as the base data grow.
