![]() This function will ask for Column to Compare, Column To be compared and Column to list the Duplicates. ![]() It will list exactly in the same row which is duplicate.ģ. This function will compare Column A with Column B and list the Duplicates in Column C but not in a Sequence. 'If you want to exchange the columns like if you want toĢ. ![]() Set CompareRange = Range("B1:" & Selection.Address) ![]() Set To_Be_Compared = Range("A1:" & Selection.Address) This function will compare Column A with Column B and list the Duplicates in Column C in a Sequence.ĭim CompareRange As Variant, To_Be_Compared As Variant, x As Variant, y As Variant Compare two columns by using Excel Macro: 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |