Is there any way auto complete can be made to work when the column contains
blank cells?
In a continuous column of data it works fine, but when spaces appear it
doesnt seem to be able to read the entries past the blank cell?