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 <[email protected]>,
excel newbie <excel [email protected]> 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?