close
Am attempting to set up database in Excel and need to format one column so
that it does not accept duplicate entries through the column?
Select the column, in this example, column A.
Select Data | Validation... | Settings tab | Allow: Custom and put the
folowing formula in the Formula box:
=COUNTIF($A:$A,$A1)lt;2
You will now not be able to create a duplicat entry in column A
Regards
Trevorquot;Selinaquot; gt; wrote in message
...
gt; Am attempting to set up database in Excel and need to format one column so
gt; that it does not accept duplicate entries through the column?
全站熱搜
留言列表
