Restricting Duplicate Entry

R

Rajat

In cell A1 to A250 i would enter employee ID (Numeric Figure) so i would
require to restrict any duplicate entry shouldnot be made in any of the cells
A1 : A250. I can't figure out how to do that ....

Any sugesstion will be welcome...
 
M

Max

One way ..

Select A1:A250

Click Data > Validation
Allow: Custom
Formula: =COUNTIF($A$1:$A$250,A1)<2
Click OK

Test it out ..
 
R

Rajat

Max

i've tried this but its not working. i can enter the same numeric figure in
more than one cell say employee ID 1 can ve entered in all the cell and the
value are accepted. Can you suggest any other way

Regards
 
R

Rajat

Max

got the answer from Jim Thomlinson response in a seperate thread
Correct Formula: =COUNTIF($A$1:$A$250,A1)=1
 
M

Max

Rajat,
.. from Jim Thomlinson response
Correct Formula: =COUNTIF($A$1:$A$250,A1)=1
Click to expand...

Jim's suggestion above works identical to mine for your post:
Formula: =COUNTIF($A$1:$A$250,A1)<2
Click to expand...

Guess I'm puzzled why it didn't work for you earlier <g>
 
Top