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

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

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

Max

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

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

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