Prevention of duplicates......

See Chip Pearson's site

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

At bottom of that page see links to other functions like highlighting
duplicates, deleting duplicates and others.


Gord Dibben Excel MVP


On Mon, 8 Aug 2005 10:59:02 -0700, texansgal
wrote:

I am wondering if there is any way to program Excel to be able to prevent
duplicating a number or a name. I can't have it sorted by either of these, I
must have it sorted by date...

Thanks,
Vanessa