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