Compare 2 excel and remove some datas


Remove old data.xlsx (11.7 KB)

In this excel sheet1 and Sheet 2 has some data. In that we need to find the last data of sheet1 is where in sheet2 and remove above data

But there r 3 column, data want to match in 3 column also
The correct output in output sheet

Hello @Aarthy1
Is data is repeated roll? You just have to find last row of first sheet to the last matching row of the second sheet.? am i correct?

Main.xaml (11.0 KB)
Try this one. provide proper naming and code. This is just a logic.
Hope this will solve.
Thanks and regards


Here’s an alternative version, just in case. :slight_smile:

ICA_RemoveLinesFromExcel.xaml (11.1 KB)

To be improved with error handling, etc… but it should give you an idea.

Last row of the sheet1 want ti match in 2 sheet data
Ic the data is match we need to remove above data in sheet 2

@Aarthy1 yes. i got the same output as you want check the flow. give proper input and output path. here the excel which i got the ouptut. sheet name is result.
Remove old data.xlsx (12.2 KB)