Setup Unique Records
 

Is there a way, in Excel, to set a certain column up as a unique record,
so that anytime i add data to the spreadsheet, if i enter in a duplicate
company name for example, it will not let me continue??

Thanks!!


--
dimebag
------------------------------------------------------------------------
dimebag's Profile: http://www.excelforum.com/member.php...o&userid=24890
View this thread: http://www.excelforum.com/showthread...hreadid=384273

dimebag, have a look here,

http://cpearson.com/excel/NoDupEntry.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"dimebag" wrote in
message ...

Is there a way, in Excel, to set a certain column up as a unique record,
so that anytime i add data to the spreadsheet, if i enter in a duplicate
company name for example, it will not let me continue??

Thanks!!


--
dimebag
------------------------------------------------------------------------
dimebag's Profile:
http://www.excelforum.com/member.php...o&userid=24890
View this thread: http://www.excelforum.com/showthread...hreadid=384273