How to define in data validation that typing the employee must be like a constant list of cities without errors
Fishing has a city called warren and I want to set up if the worker types waren - the letter r once instead of twice
You'll get an error message telling him that there's a typo
And if you can also show him the correct writing of the city - the question of whether possible in the list of 50 cities
Hi Lea,
This tutorial explains Data Validation Lists, which will do most of what you want. However, it won't correct spelling and make suggestions based on what you enter.
Mynda
Thanks
I know this command
The problem is that I have a list of 50
And I want the worker to type the name of the city and not choose from a list
The question is which formula can be set within the custom rather than the list
So Excel will allow the employee to type only a value in the original list
And if Excel does not find the value in the original list, it will send the employee an error message
Hi Lea,
The employee can type the value in cells that also contain a data validation list, they don't have to choose from the list. If they type something not present in they will get an error.
Alternatively you can use a formula to validate their entry. See file attached.
Note: I had to strip out the trailing spaces at the end of all your city names for this to work. Also, I think this approach is more likely to lead to frustration from the user as it doesn't tell them the correct spelling, it will just tell them they did something wrong. e.g. I can see Adair / Guthrie being problematic with the spaces and forward slash.
Mynda
