You may want to read some of Chip Pearson's techniques for dealing with
duplicates:
http://www.cpearson.com/excel/duplicat.htm

Visit Chip Pearson's site for a Data|validation solution:
http://www.cpearson.com/excel/NoDupEntry.htm


PANKAJ KUMAR wrote:

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

--

Dave Peterson