Matched and Unmatched data in excel

I am comparing two excel sheets with each other.
I want to match the similar data into another excel file and the rest of the data into another.
I am new in this so I dont know what to do

Kindly have a view on this

Cheers @Abad_Sid

Thanks for the fast reply.I will try it out

1 Like

Cheers @Abad_Sid

I want to do this project with the help of loop. If you can help me with that


Hi @Abad_Sid,

Kindly share the whole process with proper input and output expected. I will help you to achieve the same.


Yah that can be done as well
But using Linq is very easy while finding matches unmatched records buddy
That’s why suggested this method
And that loop method includes lot of steps that might time more time compared to this if the datatable has more records especially

Cheers @Abad_Sid

I want to compare two excel sheets and then write a new one with similarities and without similarities

I understand but If you have loop solution plz help its a project I am doing

New XLSX Worksheet (2).xlsx (8.5 KB) New XLSX Worksheet.xlsx (8.5 KB)
These are the two files I am comparing.
Main.xaml (9.2 KB)
This my workflow so far

Hey @Abad_Sid

Find below sample which will help you to understand to get matching rows in two datatables using Loop.
Abad_Sid_Sample_For_matchingRecordsUsingLoop.xaml (13.5 KB)

Let me know in case you will find any problem in understanding Logic.