Transfer Rows with Duplicate Values

ivandgreat · Feb 17th 2016

Dears,

I would like to transfer all rows that have duplicate values between 2 columns (NameA and NameB) which exist as reverse (NameB and NameA) on the same columns.

Please see attached excel file.

br,
ivan

shknbk2 · Feb 17th 2016

Re: Transfer Rows with Duplicate Values

I fixed my code errors from the previous post and included code to copy the duplicates to Sheet2.

forum.ozgrid.com/index.php?attachment/68319/

ivandgreat · Feb 18th 2016

Re: Transfer Rows with Duplicate Values

Great.
Thanks a lot shknbk2.

Transfer Rows with Duplicate Values

Participate now!

Share