I have two excel files A & B, Excel A is attached below [The image is a spreadsheet displaying errors for duplicate invoice numbers, with each row indicating an already-used invoice number for a specific supplier. (Captioned by AI)] In Excel A Column Name Your Value Excel B is attached Below […

Compare Two Excel Files and Delete Matching Rows in one excel file

rsr.chandu (Rsr Chandu) February 18, 2025, 4:35pm 6

I tried the above solution but it is not deleting the matching rows in excel b file

Topic		Replies	Views
Remove duplicate rows from two datatables based on a specific columns Activities excel , linq	8	1882	August 31, 2022
Delete Rows from a datatable after comparing with another datatable Help	4	4467	January 19, 2020
Compare 2 excel files with the same columns and remove all duplicats Help datatable , excel	5	2090	March 23, 2020
Compare two different excel columns and matched remove data in second excel sheet Studio studio , question , project_panel	19	1257	July 7, 2023
Linq query for comparing 2 datatables Activities excel , activities , question	8	1914	July 6, 2023