Loading...

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

39,826 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Sep 29, 2011

Download file: https://people.highline.edu/mgirvin/E...
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

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...