Unique number

[Mike W]

I need to make sure a number is not entered more than once in a column.
This is a sheet for taking orders, hence the need to have unique numbers.

Any help would be appreciated.

thanks,


Mike

 

[JulieD]

Hi Mike

check out Chip Pearson's web site
http://www.cpearson.com/excel/NoDupEntry.htm
he's got a section there on ensuring that duplicate information isn't
entered in a column.

Cheers
JulieD

 

[Mike]

thanks Julie, works a treat.

Mike

Hi Mike

check out Chip Pearson's web site
http://www.cpearson.com/excel/NoDupEntry.htm
he's got a section there on ensuring that duplicate information isn't
entered in a column.

Cheers
JulieD