Kiran Kumar
New Member
Hi Team,
Can you please help me to restrict entering duplicate values in A and C column.
For example, if I enter 1(A1 CEll) and 1 again in (A2) then the A2 cell should not accept and should prompt and error messages says - "Duplicate value". Same way for C column also. One more, user can enter same values in both A and C columns, but not in the same colulmn.
Column (A) Column ( C)
1 -----> Should Allow 5 -----> Should Allow
1 -----> Should not allow 1 -----> Should Allow
Thanks much for your help in advance
5 -----> Should not allow
Can you please help me to restrict entering duplicate values in A and C column.
For example, if I enter 1(A1 CEll) and 1 again in (A2) then the A2 cell should not accept and should prompt and error messages says - "Duplicate value". Same way for C column also. One more, user can enter same values in both A and C columns, but not in the same colulmn.
Column (A) Column ( C)
1 -----> Should Allow 5 -----> Should Allow
1 -----> Should not allow 1 -----> Should Allow
Thanks much for your help in advance
5 -----> Should not allow