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 *