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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dgwood90" wrote in message ...
|I want to create a spreadsheet that when a number is entered, it will state
| whether that number is already in the spreadsheet or if it is not located.