Try this page of Chip Pearson:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"lblatter" wrote in message
...
I am preparing a lengthy list which inlvoves social scurity numbers and
would
like to know if I have typed in a duplicate without doing a search each
and
every time I make an entry.

Is there any way to do this in Excel?

Thanks,