Unique records in Excel

[gilsondg]

Hi
does anyone know how to ensure Unique data when making entries in an
Excel spreadsheet ? Say Part Numbers or account numbers etc

Thanks

 

[Jason Morin]

There's a method using Data Validation and COUNTIF. Debra
Dalgleish's website has an example of how to set this up:

http://www.contextures.com/xlDataVal07.html

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/NoDupEntry.htm