How to compare the excel value displayed in different formats
I have attached an excel report. I need to compare the data from Sheet1 with Sheet2 and provide the mismatch details.
Compare the data's from column Compound ID, Compound and Formula from Sheet1 with Sheet2 with data from Column Compound Id, Compound and Formula.
Similarly Compare the data's from column Spectrum ID, Filter and RT from Sheet1 with Column Spectrum Id, Filter and Retention Time data in Sheet2.
In the attached, I have given the data only for two compounds. But in actual I will have lots of compounds.
Looking for a pattern to compare the report and a possible solution.
Thanks in advance.
Karthik K R
For this post or problem statement "How to compare the excel value displayed in different formats", I have come up with a logic to find the comparison.
Initially I thought its going to be difficult, but later on I found a pattern to compare the values and write the mismatches to the different excel file.
Regarding the post "How to compare the cell value in excel file?", its about comparing the cell value having normal string and superscript and subscript text. Even for this post, I have come up with a workaround to compare by finding the unicode characters.
Thanks for the suggestions.
Karthik K R