Compare two lists in Excel

from john on 11/20/08

This tip shows you how to quickly compare two lists (rows or columns) in Excel. In this example, we highlight all the cells that are in one list but not the other.