Ignore blanks in Dropdown list from form control
Posted on 2014-11-13
I'm using a dropdown list from the form control and populating it with a named range which gets its data from
The range accommodates about a 100 students, sometimes there are less, but the last row is always needed in the dropdown, because it has the class average. How would I ignore the blank lines when populating the dropdown.