Microsoft's Excel software is one of the best tools for you to organize, analyze, and manipulate data. Here are three ways to compare data in two columns.

The important thing to note about Formula by Example is that it only works in formatted Excel tables, not regular ranges. So, select your data, and in the Insert tab on the ribbon, click "Table." ...