Base a Data Validation dropdown on the Region values. Now, let’s use UNIQUE () to create a unique list of region values and then base a data validation dropdown on that list.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Prevent duplicates before they happen by combining a simple function with data validation.