Create a list without duplicates values in Excel
we will Create a table consisting of only non-repeating rows.
Allow typing in the column, only the non-repeating values.
Allow typing in the column only the distinct values using a special Dropdown. For this it is necessary to dynamically modify the drop-down list, consistently with the exception of a newly introduced value.
When filling cells with data, it is necessary to restrict the option of entering a specific list of values – this can be done using Dropdown. If at the same time must ensure the launch of only distinct values, you need a Dynamic dropdown list: using it the user will not be able to choose twice the same value.
If grid data is sometimes necessary to restrict the option of entering a specific list of values. For example, when filling out the statement enter the names of the employees from the keyboard can be replaced by selection from a predefined list (time sheet), and to control the re-entry of names in the list, use Conditional formatting.