compare for duplicates

[ratman]

I have an excel file with 7000 rows. Column B's&nbsp;&nbsp;alphanumeric values are 3 to 8 character lot#'s and column C's numeric values are 3 character associated suffix's. After sorting entire file by column B,&nbsp;&nbsp;&nbsp;I drag down this formula to tag all duplicate shop orders which is the combination of B's lot# and C's suffix:<br>=IF(AND(B2=B3,C2=C3),&quot;duplicate&quot;,&quot;not duplicate&quot<br>This tags all duplicates EXCEPT the last duplicate.&nbsp;&nbsp;I then autofilter all the &quot;TRUE&quot; and then print that as my exception report. I need a macro that will loop and tag ALL duplicates.&nbsp;&nbsp;I've toy'd with some <br>A=[b2].value & [c2].value<br>and some&nbsp;&nbsp;&quot;Do While A&quot;&nbsp;&nbsp;&nbsp;&nbsp;statements but no luck yet.&nbsp;&nbsp;Then it would be nice if I could print to&nbsp;&nbsp;sheet2 but only the tags are really needed at this time.