Fix Data And Large Data How To Validation With Multiple Column. 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. Var droplist p datavalidations addlistvalidation c c.
In the source box type the items of your excel validation list separated by commas. I am using the large function to get the top 15 values of table1. In my example the data in the column is a part number and the description.
2 enter this formula.
Select the cell where the dropdown list is to appear. I am using the large function to get the top 15 values of table1. In my example the data in the column is a part number and the description. I want to show the user both the part no.
