Quick tip: Excel’s “compare” function

Whatever our projects, we’re very likely to have data in an Excel spreadsheet at some point. For debugging by looking at log data, it can sometimes be very useful to compare two log files to find differences. I just learned that Excel 2013 Professional has a built in capability to do that. You need the “Inquire” tab, and then select “compare” from that. It’s an add-on, so query help for “inquire” to see how to add it to the ribbon.

Leave a Reply

Your email address will not be published. Required fields are marked *

The maximum upload file size: 512 MB. You can upload: image, audio, video, document, spreadsheet, text. Links to YouTube, Facebook, Twitter and other services inserted in the comment text will be automatically embedded. Drop files here