in excel - i have a row of cells i need to make 'unique' and do n.
 

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?

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?