I have two excel sheets with duplicate values.I need to compare column 1 and column 2 of sheet1 with column 1 and column 2 of sheet2. I need to compare both the sheets and update the output in sheet 3. I have attached the sample excel data with this. Can somebody please help me with this.
test.xlsx (11.1 KB)
Please check the workflow. Duplicate Columns.xaml (11.7 KB)
I ignored the header manipulation for now. So please don’t use unique column names for your sheets.
You may refer below post-
Thanks for the reply, but this doesn’t work in my case. I have shown the expected output in the excel sheet.
This is to get the duplicates. What I need is I need to compare. I have shown the expected output in the excel provided.