Creating a list based on a column
- by MikkoP
I need to create a dropdown list in sheet A based on the values in sheet B in column A. I clicked on the A column in B sheet and named it as Models. Then I clicked on the cell in sheet A where I wanted the list to be and selected Data -> Data validation -> Data validation. In the Settings page I selected List in the Allow section, checked Ignore blank and In-cell dropdown. In the Source section I inserted =Models.
This way I get all the right values plus a lot of blank values. How do I prevent the blank lines from appearing in the list?
