Forum Discussion

krkarthik_info's avatar
krkarthik_info
Frequent Contributor
9 years ago

How to compare the excel value displayed in different formats

Hi All,   I have attached an excel report. I need to compare the data from Sheet1 with Sheet2 and provide the mismatch details.   For E,g.,   Compare the data's from column Compound ID, Compoun...
  • krkarthik_info's avatar
    krkarthik_info
    9 years ago

    Hi Colin,

     

    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.

     

    Thanks,

    Karthik K R

joseph_michaud's avatar
joseph_michaud
Moderator
9 years ago

We have How To articles describing how to read values in Excel spreadsheets

 

Compare Excel files

Quickly Compare Excel Files

Search for Text in MS Excel

 

Looking at your Excel file, I'd say that reading the data is going to be the easy part.  It looks like the work is just going to be accounting for the different formatting on the two sheets and the fact that some values have been rounded.

    • krkarthik_info's avatar
      krkarthik_info
      Frequent Contributor
      9 years ago

      Hi Colin,

       

      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.

       

      Thanks,

      Karthik K R