Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

How to compare Microsoft Excel columns with VLOOKUP Lookup functions in MS Excel find specific information within your spreadsheet based on criteria you define. They aren't ideal for matching values.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.