Macro that will flag a duplicate line.

Hi,

So I am curious if there is a code for a macro that will flag a duplicate line for me. For instance,

A - B - C - D
1 123 Yes Ops
2 172 Yes Crt
3 187 No Crt
4 123 No Ops
5 187 No Crt Duplicate
6 172 No Ops
7 123 Yes Ops Duplicate

The macro (Or Formula if possible and easier) would flag any duplicate lines based on the Criteria in column A through C. I do not need the entire row to be identical, just three particular columns. In Addition, I would only want the second, third and so on tagged as a duplicate, not the original.

Thanks,
Justin

Here's my code from a more complex version...you can tweek it for your needs...

Please Login or Register  to view this content.