Excel Magic Trick 1110

Compare 2 Lists and Extract Records: Array Formula Method

DESCRIPTION

See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations.

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 14 times – 2 MB




Be the first to comment

Leave a Reply