Fix Data And Large Data How To Validation With Multiple Column. Suppose your data is in b2 to b10 continuously it can be easily mapped fr the list validation. I am then using index and match to find the names of the top 15 values column 2.
I am then using index and match to find the names of the top 15 values column 2. In your example it is split over b2 b4 b6 and so on so you would have to first bring them all in to a contiguous range of cells say b1 to b10. In my example the data in the column is a part number and the description.
Alternatively you can set excelrange to maxrows you can then define the range then skipping the first or first n rows.
From the data ribbon in the data tools group select data validation. Data validation is a method for checking the accuracy and quality of your data typically performed prior to importing and processing. I am then using index and match to find the names of the top 15 values column 2. I want to show the user both the part no.
