Team,
Need help here to understand the way how to do it.
1. I have two files.
2. Both files has data in it.
3. I am trying to compare each line and delete the duplicate in File 2.
4. Save the File 2 as fresh file in same folder.
I tried to use Concatenate to get the data in single column, and do a Vloop up in file 2. But doing so, if there is 2 rows for same ID, then in vlook up it picks up the first record. Making loop hole in the method.
Any other possible for to get this done?
Thanks,
Bookmarks