Main Profile

At A Glance

Excel 2010 Magic Trick 813: Compare Two Lists Extract Items In List 2 That Are Not In List 1

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See how to compare two lists and extract items from List 2 that are not in List 1 2. Use a Helper Column with a formula that uses the formulas SUM, ISNA, and MATCH functions 3. Use a lookup formula for the extracted list that uses VLOOKUP and IFERROR functions. 4. Compare Two Lists 5. Compare Two Tables
Length: 06:18

Contact

Questions about Excel 2010 Magic Trick 813: Compare Two Lists Extract Items In List 2 That Are Not In List 1

Want more info about Excel 2010 Magic Trick 813: Compare Two Lists Extract Items In List 2 That Are Not In List 1? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question