(Solved) : List Option Group Data Validation Settings Generate Error Message Value Included List Ente Q35338962 . . . .

With the List option in the group of data-validation settings,you can generate an error message if a value that is not includedin a list is entered in the cell range you’re validating.Supposeyou’re entering employee first names in the cell range A1;A10. Theonly employees of the company are Jen, Greg, Vivian, Jon, ad John.Use the List option to ensure that no one misspells a firstname.

USE EXCEL

Expert Answer

An answer will be send to you shortly. . . . .