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).
|