can i not allow duplicate values in the same column?

[excel newbie]

is there a way to set columns to not accept duplicate information?

 

[JE McGimpsey]

Take a look at

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

 

[Peo Sjoblom]

If the values are typed in you can use this:

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


Regards,

Peo Sjoblom