• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index, Match and maybe Offset

arnold muscat

New Member
Hi, I would like to be able to do reconciliations in Finance, whereby one data set is compared against another and identify the different or similar values. This would greatly speed up finding differences.

It is possible by using conditionally formatting and =not(a1=d1),if the data being compared is in the SAME row. I want it to find the same data anywhere in the data set.

Many thanks



New Member
Arnold.. you can try the conditional formatting tips here.. I am sure there are multiple examples on this : http://chandoo.org/wp/tag/conditional-formatting/