Check out Chip Pearson's method:
http://www.cpearson.com/excel/NoDupEntry.htm
Regards,
Greg
-----Original Message-----
Is there any way of preventing an end user from entering
in the same entry twice in a column,like a primary key?
The object is the have the end user enter a loan number
once on the spreadsheet.
.