software

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,

Try this page of Chip Pearson:

www.cpearson.com/excel/NoDupEntry.htm

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;lblatterquot; gt; wrote in message
...
gt;I am preparing a lengthy list which inlvoves social scurity numbers and
gt;would
gt; like to know if I have typed in a duplicate without doing a search each
gt; and
gt; every time I make an entry.
gt;
gt; Is there any way to do this in Excel?
gt;
gt; Thanks,