Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for converting excel to adobe pdf | Excel Discussion (Misc queries) | |||
HOW TO COMPARE COLUMN VALUES IN EXCEL? | Excel Worksheet Functions | |||
Converting a row or column in excel to a Javascript array | Excel Discussion (Misc queries) | |||
compare data from one column with another and compare result to yet another | Excel Programming | |||
macro for converting text file to excel | Excel Programming |