By using you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes


2011-05-17 The Files are Different

Today a user calls me to complain that a file I sent them is very different than a previous file I sent.

So how do you compare two files against each other? I use a spreadsheet called CompareSheets.xls to determine the differences. The program will:

1. Get you to select the two files you want to compare
2. Press a button to start the comparison
3. Compare the data cell by cell and display a list of differences

After the comparison runs the sheet allows me to step by step view the differences in the two files. I examine the data and notice that the differences are caused by the user adding a formula while the sheet was filtered on one sheet but not the other.

This is a case where developing tools for my work paid off. I was quickly able to diagnose the problem.

It also reminds me that you should always compare output against a previous working or validated output to make sure you haven't changed anything.
blog comments powered by Disqus
Home | About | Feedback| Privacy | Terms of Service | @alecberg | FAQ | | Copyright © 2022 All Rights Reserved. Edit
This site uses cookies. If you don't want cookies and who doesn't want them as they're yummy, then leave.