can i not allow duplicate values in the same column?
 

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

Take a look at

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

In article ,
excel newbie <excel wrote:

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

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?