When analyzing data in Excel, you may need to compare two or more lists to find the differences. There are many ways to go about doing this, but surprisingly, the Go To command provides a really quick and easy way to accomplish this.
First, highlight the lists that you want to compare. If they aren’t in adjacent columns, select one list, then hold down the ctrl key while highlighting the rest. Then press F5 (the shortcut key for the Go To command) and click the Special button. If you are using Excel 2007 or later, you can also click the Find & Select button on the ribbon and choose Go To Special. In the window that pops up, choose Row Differences and click OK. Excel will highlight the cells that contain differences. If you want to flag those differences so you can find them again, just click the Fill Color button while the cells are still selected.