Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering for unique records | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) | |||
unique records | Excel Worksheet Functions |