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" <[email protected]> wrote in message
news:[email protected]...
>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?