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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"gtoffice" wrote in message
...
i have records that i do not want duplicated on the worksheet, how do i set
excel spreadsheet up so that 2 of the same numbers cannot be inputted?