If the values are typed in you can use this:

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


Regards,

Peo Sjoblom

"excel newbie" wrote:

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