Main Profile

At A Glance

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

Contact

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

Want more info about Excel 2010 Magic Trick 816: Compare Tables & Extract Records In Table 2 That Are Not In Table 1? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question