Hiii..
I have created an excel table with two columns (1st column has 10 items & 2nd one has 6 items).
Now I am using this table (2nd column) to create a Data validation list for drop down.
I have used the following formula in the source list : =Indirect("Table1[column2]") to get all the 6 items dropdown.
Issue is the dropdown has 4 blank rows below as the table 1st column has 10 items in it.
I want to exlcude those 4 blank rows from the dropdown.
What is the solution?
Thank you.
Bookmarks