Create a list without duplicates values in Excel

Create a list of distinct values by choosing values from a previously defined list. To select values using drop-down list.

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.