### Excel 2010 Magic Trick 816: Compare Tables & Extract Records In Table 2 That Are Not In Table 1

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm1. See how to use a Helper Column and a few formulas that use the functions MATCH, IANS, SUM, INDEX and MAX functions to extract records in table 2 that are not in Table 12. Helper column helps to avoid a large array formula and helps to speed up calculations time.

Length:
08:31