I have the below macro that in essence, without physically doing so,
joins together together and compares if there are duplicate versions
of each combination and flags them all as duplicate. Can someone help
me create a VBA version of this so I can run it on the fly instead of
having to paste it down a column to run? By the way, object_name and
object_type are column headers for A and B and since this is a macro
A1 and B1 keep incrementing right now as they go down the rows.
Thanks.

=IF(AND(COUNTIF(object_name,A1)1,COUNTIF(object_t ype,B1)1),"<<Duplicated
Value","")

JR