Setup Unique Records

dimebag · Jul 4, 2005

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

Paul B · Jul 4, 2005

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