I have two excels having same columns and some duplicate data. for ex:
excel1: column1,column2,column3
A,B,22/12/2019
C,D,23/12/2019
excel2: Column1,Column2,Column3
A,E,22/12/2019
C,D,23/12/2019
Output excel: Column1, Column2,Column3
A,E,22/12/2019
By comparing excel1 and excel2 i found one duplicate. so output should be without duplicate and the value should be taken from excel2 not from excel1.(ie, excel1 : A,B,22/12/2019 is not a duplicate but it should not be taken in output excel only the output of excel 2: A,E,22/12/2019 need to take)
@pattyricarte for your reference i created dummy data having 3 excels as “old data” which is already having past data in it. “Input” which is a new sheet having new data. after comparison the output should be stored in “output”