Forum Discussion
Excel help needed in comparing Data
Hi All I need some help with excel formula. Here is my problem statement. Any help/pointers on how to solve this is really helpful I have 2 documents - Doc1 and Doc2. Below is sample forma...
Jack67 See if you can get the formulae as per the attached workbook into your own. I've used named ranges to avoid direct cell references and there are probably several other ways to do it. This, however, was the first that came to mind without giving it much further thoughts.
By the way, the formulae actually result in TRUE or FALSE. With the double dash "--" in front, these become ones and zeroes. These are then custom formatted to display Yes or No.