Trying to make Excel work like Access or any other application can be a
challenge but you might try this:

Say you require that every entry in column A be unique. Select all of
column A by clicking the column A heading. Make sure that cell A1 is the
active cell. Then do a Data, Validation and pick Custom as the Allow type.
In the formula box enter: =COUNTIF(A:A,A1)=1

Customize the Alert tab to show the user a helpful error message.


--
Jim
"PANKAJ KUMAR" <PANKAJ wrote in message
...
|I want to make a row which can't accept a duplicate entry ( jst as
MS-Access
| Primary Key Field).
| Please suggest, as its urgent.
|
| Thanks & regards
|
| Pankaj
| IS Executive
| DTDC Courier & Cargo Ltd.
| New Delhi
| Mob. 9313003826
| Phone:- 011-51514148, 51514197 Extn. 23