Match

This Analytics Edge wizard is used to keep or remove rows based on whether matching row values exist in another table or worksheet.

It is usually used by taking the result of one analysis (top product sales, most popular links) and filtering a detail report to see what contributed to the ranking.

Match with – select a Worksheet or previously named Table from the drop down list.  The worksheet must be in the same workbook, and data must start in cell A1, and it must include a header row. If you want to use a table in memory, use the Table Name function to create the reference.

Select Columns – select the columns that will be used to align the two tables together. All values from all of the selected columns must match for a row to match.

Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters (applies to text columns only).

Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (applies to text columns only).

Keep matching rows – keep only rows that have matching rows in the reference table.

Remove matching rows – remove rows that have matching rows in the reference table.

Blog article: Using the Match Function

Updated for v10.