How do I prevent duplicate entry of a sku in a data table?
 

I want to keep folks from entering the same sku into a table (i.e. like data
validation does for other parameters).

How do I prevent duplicate entry of a sku in a data table?
 

Assume that you want to restrict the users from typing the duplicate values
in A Column.

Place the cursor in A1 cell and press Cntrl+Spacebar which will selecte the
A Column. Keep in mind that the active cell should be A1 cell. (Active cell
will have a white background after selection also)

Data ValidationSettingsValidation CriteriaAllowCustom and in
Formula paste this =COUNTIF(A:A,A1)=1

DataValidationError Alert Title enter this €œValue Already Exist€�

DataValidationError Alert Error Message enter this €œColumn already
consist this Value, So try some other value€�

Like this you can restrict the users by typing the duplicate value.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"hscja" wrote:

I want to keep folks from entering the same sku into a table (i.e. like data
validation does for other parameters).