The above is input file.
Like this i have two input files.The data is same as this file only the column name changes and all the data are unmerge in second input file,unlike above input file.
Here is the ouput sheet.
Note: where .mht is written is the second input file and where Excel is written is the first input file.
The requirement is like we can have any number of .mht input file and for that only one excel file is there.
If 3 .mht file is there so we will compare one row of excel with 3 .mht file.
Here we need to get unique value of column Entrycode, Col_D, Deal and Z_deal.
Note that in 1st input excel file thr Entry code and Col_D column is merged but in output it is unmerged.
I m stuck in a project