Restricting Duplicate Entry

[Guest]

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

 

[Max]

One way ..

Select A1:A250

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

Test it out ..

 

[Guest]

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

 

[Guest]

Max

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

 

[Max]

Rajat,

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

Jim's suggestion above works identical to mine for your post:

Formula: =COUNTIF($A$1:$A$250,A1)<2

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

---

 

[Max]

It should work. Perhaps the validation wasn't implemented correctly in your
try.