I read many articles how to apply Autocomplete with an datavalidation field. But my problem is dat those solutions are windows based and I am using Excel on an Mac.

Also the dropdownbox solution is not working in my version. There are very few settings that i can change.

Hope someone knows a good solution to solve this issue.