software

How do I validate that the data entered in a worksheet is not a
duplicate from a list of 150 names. I have two columns with the same
list, and need a way to prevent dual entries.

Jonahquot;Jonahquot; wrote:
gt; How do I validate that the data entered in a worksheet is not a
gt; duplicate from a list of 150 names.
gt; I have two columns with the same list,
gt; and need a way to prevent dual entries.

Assume the 150 names are in col A
and col E is the 2nd input col

Select col E
Click Data gt; Validation
Allow: Custom
Formula: =COUNTIF(A:A,E1)lt;1
Click OK

Test it out ..

Perhaps a better alternative is to use a defined range,
eg: NList =Sheet1!$A$1:$A$150
(Defined ranges can be created via: Insert gt; Name gt; Define)

Then we could validate the quot;2ndquot; input col within any sheet
via the same steps above,

eg: assuming col E in Sheet3 is the quot;2ndquot; input col

In Sheet3,

Select col E
Click Data gt; Validation
Allow: Custom
Formula: =COUNTIF(NList,E1)lt;1
Click OK
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---