Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color

Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to Extract Items From List 2 that are NOT in List 1 by using Conditional Format Unique Values, Sort by Color, and Copy and Paste Thanks to Our Excel Online Team: Manaz101 at YouTube Yuvaraj Krishnamoorthi at YouTube Related Videos for Comparing Two Lists and Extracting Records: Other Excel Methods for Comparing Two Lists: Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) https://www.youtube.com/watch?v=9h1omv60MCA Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color https://www.youtube.com/watch?v=E3_vMI3LjJU Excel Magic Trick 1441: Power Query to Extract Items In List 1 That Are NOT In List 2 https://www.youtube.com/watch?v=JztEKJ-XkCU Excel Magic Trick 1442: DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 https://www.youtube.com/watch?v=lLMXFLr9Aeg