<div>
There is no attachment.<br />
<br />
However, you can do this without VBA.<br />
<br />
Put this in column E (assuming header on row one, start with E2):<br />
<br />
[E2]=IF(COUNTIF($D$2:$D2,$<wbr />D2)&gt;1,1,0)<wbr /><br />
<br />
and copy down.<br />
<br />
You can then filter the range on column E for 1, and delete those rows.<br />
<br />
Dave
</div>


There is no attachment.

However, you can do this without VBA.

Put this in column E (assuming header on row one, start with E2):

[E2]=IF(COUNTIF($D$2:$D2,$D2)>1,1,0)

and copy down.

You can then filter the range on column E for 1, and delete those rows.

Dave

removeDupes-r1.xls

removeDupes-r2.xls

<div>
Perfect, thank you very much.
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I was wondering if anyone would anyone know of any VBA code that would get rid of duplicates. &nbsp;For example, in Column D, I want to keep the first instance of the ID, and get delete the duplicate(s).<br />
<br />
I have attached the a file with data.<br />
<br />
I am using Excel 2003. &nbsp;<br />
<br />
<br />
<br />
Regards<br />
<br />
Greg
</div>
</div>


Hi

I was wondering if anyone would anyone know of any VBA code that would get rid of duplicates.  For example, in Column D, I want to keep the first instance of the ID, and get delete the duplicate(s).

I have attached the a file with data.

I am using Excel 2003.  



Regards

Greg

VBA to get rid of duplicates - Excel 2003

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