How do I prevent duplication information, such as SSNs in cells.

G

Guest

Is there a way to prevent duplication of numbers in Excel cells such as
Social Security Numbers. Can an alert be set to get notification when a
duplication is entered in another cell in the same colomn occurs?
 
G

Guest

Select A1:A10, the use Data / Validation... on the "Settings" tab,
Select Custom under "Allow"
and use the formula

=COUNTIF($A$1:$A$10,A1)=1
--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

prevent reading or any access to selected cells 2
Formatting Text in cells that already have text entered 5
Preventing Duplicate Cells 2
prevent duplication 1
Identifying Identical Cells 2
How do I prevent duplication of numbers in a column 2
How do I prevent duplicate entries in a Field? 1
Prevent duplication across sheets 2

Top