Excel list does not ignore blanks

Describes the cause and action for error messages.

Error Message(English)：
list does not ignore blanks

Resolution

Excel Data Validation Tips and Troubleshooting - Contextures
https://www.contextures.com/xlDataVal08.html

Data Validation Combo Box
https://www.contextures.com/xlDataVal10.html

Dependent Drop Down
https://www.contextures.com/xlDataVal13.html

Select Multiple Items from ...
https://www.contextures.com/excel-data-validation-listbox.html

Excel Ignore Blanks in Data Validation List ? My Online Training Hub
https://www.myonlinetraininghub.com/excel-ignore-blanks-in-data-validation-list

Ignore Blank Problems in Excel Data Validation - YouTube
https://www.youtube.com/watch?v=_Q1f_FlvwWg

https://www.youtube.com/watch?v=_Q1f_FlvwWg

How to create drop down list ignore blank cells in Excel? - ExtendOffice
https://www.extendoffice.com/documents/excel/2445-excel-drop-down-list-ignore-blank.html

How to create a dynamic list without blank in Excel? - ExtendOffice
https://www.extendoffice.com/documents/excel/2654-excel-dynamic-list-remove-blanks.html