Avatar of zerog
Flag for South Africa

asked on 

Ignore blanks in Dropdown list from form control

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.
Microsoft Excel

Avatar of undefined
Last Comment
Jacques Geday

8/22/2022 - Mon