Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1108-1110.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm 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.