Restricting Duplicate Entry
 

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

Restricting Duplicate Entry
 

One way ..

Select A1:A250

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

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rajat" wrote in message
...
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...

Restricting Duplicate Entry
 

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

Restricting Duplicate Entry
 

Max

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

Restricting Duplicate Entry
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rajat" wrote in message
...
Max

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

Restricting Duplicate Entry
 

It should work. Perhaps the validation wasn't implemented correctly in your
try.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rajat" wrote in message
...
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