<div>
can't think of any formulas but there are some built-in items:<br />
1. you can always due a unique filter (Data - Advanced Filter - check unique items)<br />
2. when entering info in the same column, excel will do an autofillin for that column.<br />
<br />
other than that, all I can think of is vba code.
</div>


can't think of any formulas but there are some built-in items:
1. you can always due a unique filter (Data - Advanced Filter - check unique items)
2. when entering info in the same column, excel will do an autofillin for that column.

other than that, all I can think of is vba code.

<div>
Comment will be allowed, was advised of improper advertising in Community Support. &nbsp;I have re-thought my position on this, and have placed the comment back to it's origal state.<br />
<br />
My mistake,<br />
ComTech<br />
CS Admin @ EE
</div>


Comment will be allowed, was advised of improper advertising in Community Support.  I have re-thought my position on this, and have placed the comment back to it's origal state.

My mistake,
ComTech
CS Admin @ EE

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
When entering data in excel, is there some kind of formula to help you identify whether you have repeated data in the same column. &nbsp;Say I enter 300 ID Card numbers and I would like to check whether they are all unique or whether I have some repetitions. &nbsp;I just want to know how many cases of repetitions there are. &nbsp;I don't want a primary key field like in Access that does not allow you to enter a repeated value.<br />
<br />
Thanks
</div>
</div>


Dear Experts,

When entering data in excel, is there some kind of formula to help you identify whether you have repeated data in the same column.  Say I enter 300 ID Card numbers and I would like to check whether they are all unique or whether I have some repetitions.  I just want to know how many cases of repetitions there are.  I don't want a primary key field like in Access that does not allow you to enter a repeated value.

Thanks

Excel  check for double entries

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.