<div>
as a primary key for what?<br />
<br />
Please explain more or provide a sample sheet.<br />
<br />
Thanks,<br />
<br />
Dave
</div>


as a primary key for what?

Please explain more or provide a sample sheet.

Thanks,

Dave

NoDupes-In-Col-A.xls

<div>
Also I forgot to mention, the code works only for range A1 to A100. Please increase the range as applicable.<br />
<br />
Sid
</div>


Also I forgot to mention, the code works only for range A1 to A100. Please increase the range as applicable.

Sid

<div>
Hi experts<br />
Column a can be any text but &nbsp;can not duplicate<br />
when user type it can not duplicate
</div>


Hi experts
Column a can be any text but  can not duplicate
when user type it can not duplicate

<div>
Did you check the file that I posted ?<br />
<br />
Sid
</div>


Did you check the file that I posted ?

Sid

<div>
<div class="content wysiwyg-content">
how can i set up colum A can not duplicate
</div>
</div>


how can i set up colum A can not duplicate

excel set up primary key

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.