Thank you Stephen,

I was trying to figure this out without having to create a drop down list,
but it looks like that is what I might have to do. It is very curious
though, there are cells where I am typing the same name in a column (no other
names in between) and it does not autocomplete, but there are other names
that only show up once or twice in the entire spreadsheet and autocomplete
works!