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 compare Excel sheets for efficient bank reconciliation with step-by-step tips on data prep, pivot tables, discrepancy analysis ...

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...