Find Duplicates Based on Two Columns

[santhoshkunder]

Dear All

I want to find the duplicates based on two columns.For Example I have Value ABC in Cell B1 and Value XYZ in C1. This is reversed in second Row means XYZ in B2 and ABC in C2. When I concatenate this It is one and same for me. ABCXYZ and XYZABC. Just the values are interchanged. Now i need the duplicate values.I have uploaded the file to avoid the confusion.

Please help me on this
santhosha

 

[NARAYANK991]

Hi Santosh ,

Something like this ?

Narayan