<div>
<div class="content wysiwyg-content">
I have a spread sheet with 14k entries containing first name, last name, city, and email address. &nbsp;I want to flag duplicates. &nbsp;My thought was to place an &quot;x&quot; in column E next to all duplicate entries. &nbsp;I am having trouble with the formula. &nbsp;Any help would be much appreciaed.
</div>
</div>


I have a spread sheet with 14k entries containing first name, last name, city, and email address.  I want to flag duplicates.  My thought was to place an "x" in column E next to all duplicate entries.  I am having trouble with the formula.  Any help would be much appreciaed.

Excel Duplicate Search

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