Converting two column compare macro to vba in Excel
 

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

Converting two column compare macro to vba in Excel
 

John,
In the following table which Dup's you want to Flag
o_name o_type YourFormula Dup'sColA Dup'sColB A&B
Bozak Qedis <<Dup's <<Dup's <<Dup's BozakQedis
Runas Niwee
RunasNiwee
Nobul Fopal
NobulFopal
Qedis Karis <<Dup's
QedisKaris
Majog Kudes
MajogKudes
Qedis Zobij <<Dup's <<Dup's <<Dup's QedisZobij
Macel Aavej <<Dup's <<Dup's <<Dup's MacelAavej <<Dup's
Aavej Jadog
AavejJadog
Jadog Jimev
JadogJimev
Filid Bozak
FilidBozak
Yopiw Rubah
YopiwRubah
Macel Aavej <<Dup's <<Dup's <<Dup's MacelAavej <<Dup's
Tiser Qedis <<Dup's
TiserQedis
Bozak Cafea <<Dup's
BozakCafea
Repih Repih
RepihRepih
Zobij Tiser
ZobijTiser
Nineb Aavej <<Dup's
NinebAavej
Kameh Zobij <<Dup's
KamehZobij

Cecil

"John" wrote in message
om...
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