On my project, I am not 100% on development. My job also requires preparation of integration tests which consist of getting an excel file from business people, extract the information and compare them with the information the system generates.
I encountered a strange and silly problem today while working on excel: I needed to validate if two columns have the same value. On the right side, I have a value formatted like :
and on the left side I have another date value formatted like :
When I did
the result was false. A colleague of mine suggested the following and it works :