Hi, I have two separate excel files of 1 column each but might have different number of rows. I need to compare these two files and find the difference between them. For example: File 1 contains: 123 abc 456 File 2 contains: 123 abc xyz123 456 789 So I need the result to look like this: …

Comparing two separate Excel files and keeping only unique results

alin.c.mihalea August 18, 2020, 7:46am 10

I guess that might happen if there are no unique values from the 2 datatables. Basically, the 2 datatables are identical.

I made some changes to the initial workflow in order to handle this.

1 Like

I need help comparing 2 excel files

Topic		Replies	Views
Compare two excels and remove duplicates from it Help datatable , excel , activities , question	11	2462	December 5, 2019
How to Compare two datatables and write only unique values in first datatable Help excel , activities , question	4	2010	December 31, 2020
To Compare two excel & get unique rows based on column Activities excel , activities , question	10	812	March 10, 2023
Comparing Two excel files Help excel , activities	25	7261	June 2, 2021
Compare 2 excel files with the same columns and remove all duplicats Help datatable , excel	5	2099	March 23, 2020